voo33

OLEDB Enterprise 2010 Timestamp issue

Discussion created by voo33 on Jun 27, 2012
Latest reply on Jun 27, 2012 by voo33

Hello v-campus members,

 

I ran into some issue when I tried to extract only the date part from a timestamp using OLEDB enterprise 2010. The timestamp is the query result from data.archive table, which contains both date and time parts, for example: '2/1/2012 10:45:00 PM'. However, I have to get rid of the time part, getting '2/1/2012' only. Also, the returned value has to stay as a datetime type as well.

 

Is there someone could help me on this?

 

Thanks in advance!!

 

Shanshan

Outcomes