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

srikanth_chinna — Fri, 22 Jan 2021 19:47:08 GMT

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:

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" .
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:

How do i change the date format as explained in above scenario?
Can't we convert the Date formats in Snowflake Using Talend?
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

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

manodwhb — Sun, 24 Jan 2021 04:42:09 GMT

@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

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

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

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