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!!