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