Results 1 to 2 of 2
  1. #1
    Join Date
    Nov 2015
    Posts
    2

    Unanswered: Oracle sydate to db2 timestamp converion

    I want to convert the sysdate from oracle to the equivalent timestamp in DB2. Can somebody help me out with the query to do the same?

  2. #2
    Join Date
    Jul 2013
    Location
    Moscow, Russia
    Posts
    666
    Provided Answers: 55
    select timestamp(current timestamp, 0) from sysibm.sysdummy1
    Regards,
    Mark.

Posting Permissions

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