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