Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
My source is a .CSV file and Target is Snowflake.
I need to convert Input file date "2007-01-21" to "21-JAN-07" in Snowflake output using tMap in Talend.
Data type is "DATE" for both Input(.CSV file) and Output(Snowflake).
What i have done so far:
Questions:
Please help as i'm struck on this since 2 days trying different methods.
Thank you
Srikanth Chinna
@not specified not specified ,try to use this format to dd-MMM-yy first convert sting to date yyyy-MM-DD and then format one date to other date (dd-MMM-yy).
Thanks,
Manohar