• No replies
1 Post

Pinned topic truncate the time stamp in db2

‏2012-05-08T20:38:34Z |
Hello Everyone,
I am new with DB2 databases. I want to be able to truncate the time stamp from a date-time field in DB2. For example if MyDate field has an entry '5/8/2012 4:40 PM', I want to just want the date part of it '5/8/2012'. How can we achieve this in DB2.
Thanks in Advance