Results 1 to 2 of 2
  1. #1
    Join Date
    May 2011
    Posts
    1

    Unanswered: DB2 command remove the 'date' string from the timestamp.



    Hi,
    What is the DB2 command to remove the 'date' string from the timestamp?
    Ex input : 2011/04/15 14:17:10.000
    Sample output : 04/15/2011
    Could someone revert with an example? Thanks.

  2. #2
    Join Date
    Jan 2003
    Posts
    4,292
    Provided Answers: 5
    If your column data type is timestamp and you want to return the date portion: date(column1).

    Andy

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •