regarding the date conversion

[vijaya]

I am using server edition,I have to populate in my target enddate column as "2045/11/08" i enddate column datatype is timestamp i am tried aboveformat and "2045/11/08 00:01:00" but it is showing only year "2045/00/00" how can i populate the whole thing

[DS_SUPPORT]

Vijaya,

What is ur Input Date Format and what is your Target Database and How you are converting it in the Transformer stage?

[vijaya]

my input date format is dd/mm/yyyy and my target db is oracle and that conversion i did uing right.tag

[DS_SUPPORT]

Iconv and Oconv can be used for converting dates. You can use something like

Code: Select all

Oconv(Iconv(InputColumn,"D/DMY[2,2,4]"),"D-YMD[4,2,2]") : ' 00:00:00'

Use the Search facility for Iconv & Oconv, You can find N number of posts.

Thanks
DS_SUPPORT

[goosarikiran]

Hi

You can concatenate the date with "00:00:00.000". it will be converted to time stamp.

[chulett]

No, that just adds a zero time to a given date but doesn't automagically make it a 'timestamp'. Plus you may (or in this case not) need the milliseconds you've added on.

A timestamp is a date/time in a specific format, usually ISO like so:

YYYY-MM-DD HH24:MI:SS

So there's typically more than just sticking zeroes on the end.