Forum Discussion

arvindnsn's avatar
arvindnsn
Contributor
2 years ago
Solved

Converting String into Snowflake Datetime

Hello,

 I need to insert the string " 30/01/2024 00:00 'DD/MM/YYYY HH24:MI' " into Snowflake Timestamp_NTZ(9) column as " 2024-01-30 00:00:00.000 'yyyy-MM-dd HH:mm:ss.SSS' ". I tried the following with no success. Any help would be appreciated.

1. Date.parse($var_date).toLocaleDateTimeString({"format":"yyyy-MM-dd HH:mm:ss.SSS"})

2. Date.parse($var_date, 'DD/MM/YYYY HH24:MI').toLocaleDateTimeString({"format":"yyyy-MM-dd HH:mm:ss.SSS"})

Tried the above and getting error.

Thanks

Aravind N

 

 

 

 

  

  • SpiroTaleski's avatar
    SpiroTaleski
    2 years ago

    @arvindnsn  

    Probably the easiest way is to remove the part "DD/MM/YYYY HH24:MI" from the input string, parse it and converts it to a target date-time format. 

    Date.parse("30/01/2024 00:00 'DD/MM/YYYY HH24:MI' ".substr(0,"30/01/2024 00:00 'DD/MM/YYYY HH24:MI' ".indexOf("'")).trim(),"dd/MM/yyyy HH:mm").toLocaleDateTimeString({"format":"yyyy-MM-dd HH:mm:ss.SSS"})

2 Replies

  • SpiroTaleski's avatar
    SpiroTaleski
    Valued Contributor
    2 years ago
    Copy LinkReport

    @arvindnsn  

    Probably the easiest way is to remove the part "DD/MM/YYYY HH24:MI" from the input string, parse it and converts it to a target date-time format. 

    Date.parse("30/01/2024 00:00 'DD/MM/YYYY HH24:MI' ".substr(0,"30/01/2024 00:00 'DD/MM/YYYY HH24:MI' ".indexOf("'")).trim(),"dd/MM/yyyy HH:mm").toLocaleDateTimeString({"format":"yyyy-MM-dd HH:mm:ss.SSS"})