Results 1 to 2 of 2

Thread: DB2 timestamp

  1. #1
    Join Date
    Jun 2013

    Unanswered: DB2 timestamp

    Hi All,

    Please help me , Currently I am using MM-DD-YYYY HH:MMS format for SQL Server. Now is there any option to set / alter DB2 timestamp format at database level.
    Just as example: In oracle also same issue but we can alter date format through NLS_DATE_FORMAT at database level.

    I need to save datetime format just like : MM-DD-YYYY HH:MMS

    Please Help!

    Thanks in Advance

    Raveendra Singh

  2. #2
    Join Date
    Jan 2003
    Provided Answers: 5
    DB2 an an internal format for the timestamp that cannot be changed. Its the format that is delivered to the client that can be changed. Look at: IBM DB2 9.5 Information Center for Linux, UNIX, and Windows


Posting Permissions

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