ETL and Data Integration tools - Modern ETL software for everyone

I want to insert sysdate into a target table's column and not able to insert i selected the date format as M/D/YYYY but rest of the data and fields are loaded except sysdate field.How to insert sysdate using sql command from import process

rgds
jelson

Jelson

Here are couple of examples which might help you

This one will not load any data because no date format was provided

This one will load data

If your target database is oracle you may also use oracle functions to achieve the same result.


Hope that helps,
Mike

Hi
the date format i am giving M/D/YYYY and is there any way we can change the format.I tried different format but its not working

rgds
jelson

Is it working now?
Is there anything we can do to help?

Mike

Hi Mike
I mapped the sysdate and its worked and i didnt tried the method you mentioned in the screenshot but it will be useful and i dont know whether M/D/YYYY is the only supported format for import method cos when i changed to any other format its not inserting the data

rgds
jelson

Jelson

I am glad it worked for you

Just for your information

Format is used for source data, not for target

If your source data in M/D/YYYY format this is the format you should use.

Mike