Skip to content
Advertisement

Tag: string-formatting

How to Convert Array or String in Snowflake to Timestamp_NTZ

I currently have some incoming datestamps as from outside datasource, but am struggling to define them in a table through my Snowflake Tables. The column is formatted as such: {“type”:”TEXT”,”length”:12,”byteLength”:48,”nullable”:true,”fixed”:false} The only current workaround I have is this convoluted code. Any suggestions to convert string to integer for timestamp? Answer Assuming the format of input ‘YYMMDDHH24MISS’ and first 22 stands

Advertisement