Converting String into Snowflake Datetime

Question

Hello,&nbsp;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.ThanksAravind N&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;

spirotaleski · Accepted Answer

@arvindnsn&nbsp;&nbsp;Probably the easiest way is to remove the part&nbsp;"DD/MM/YYYY HH24:MI"&nbsp;from the input string, parse it and converts it to a target date-time format.&nbsp;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"})

Forum Discussion

Converting String into Snowflake Datetime

Recent Discussions

Javascript to promote top level lists

Google Sheets Subscribe questions

Basic string transformations not working

Can we generate XML file in pretty print format using native snapLogic snaps?

Multipart Reader failure - 'content-type' was not found