How to convert Input (.CSV) date format "2007-01-21" To output (Snowflake) date format "21-JAN-07" using Talend tMap.

[srikanth_chinna]

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:

1. Mapped the Input port and output port directly and changed the output schema date type format to " dd-MMM-yyyy" or "MMM-dd-yyyy" -- Both didn't work. Output in Snowflake is displaying as-is from source "2007-01-21" .
2. Tried converting input Date to String and String to Date in Expression editor - Didn't work. Output in Snowflake is displaying as-is from source "2007-01-21" .

Questions:

1. How do i change the date format as explained in above scenario?
2. Can't we convert the Date formats in Snowflake Using Talend?
3. Do i need to change any settings in Snowflake?

Please help as i'm struck on this since 2 days trying different methods.

Thank you

Srikanth Chinna

[manodwhb]

@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