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 w...
  • 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"})
SpiroTaleski's avatar
SpiroTaleski
Valued Contributor
2 years ago
Copy Link

@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"})