Date Timestamp

indu

• July 11, 2011 00:00

• Answered

Follow

Hi,
How can i insert system date with timestamp(2011-07-11 15:05:00) into Oracle DB.
In the Date Functions I see that there is today() function which returns only date(2011-07-11).

Thanks,
Indu

• 

  avackova

  • July 11, 2011 14:06

  0

  Comment actions Permalink

  Hello Indu,
  today() function returns full date with time. You have probably date format on the metadata, that sends data to DBOutputTable (for more information see Metadata:format).
• 

  indu

  • July 12, 2011 09:44

  0

  Comment actions Permalink

  Thanks Agata. Didnt know that we could set the format in Metadata. It worked :)

Please sign in to leave a comment.