Date Timestamp

CloverDX Platform
1

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

2

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).

3

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