I am attempting to load a CSV file that has timestamps in it. I cannot figure out the proper Timestamp format to use to consume these timestamps correctly. Any suggestions would be greatly appreciated

mgill1610467628477 · February 16, 2021, 4:33pm

I have tried "YYYY-MM-DD HH:MI A"; "YYYY-MM-DD HH:MI"; "YYYY-MM-DD HH:MM A"; "YYYY-MM-DD HH:MM".

Some examples of the values in the timestamp columns are :

2021-02-13 12:00 AM

2021-01-06 5:45 PM

0000-00-00 00:00:00

Nils · February 17, 2021, 1:30pm

For me ''YYYY-MM-DD HH12:MI AM'' is working on Snowflake.

But your 0000-00-00 00:00:00 will cause issues because this has not the same format and is no valid date/timestamp.

So you have to replace this value using a dummy or NULL.

One solution could be to import the data as string and do the calculation/casting afterwards.

Murali · February 17, 2021, 5:20pm

Loading it as VARCHAR and then dealing with the values later is the best way to go.

Topic		Replies	Views
Is there a way to convert epoch timestamp to a human readable datetime? Matillion ETL	6	0	April 7, 2022
Database query is adding timezone to datetime data when loading from SQL Server Matillion ETL	3	2	February 22, 2022
Hello All, In Matlllion ETL we have Database Query component, Which stages the data, onto S3 Storage, So overthere i could see that it doesnt have any file format(csv)etc ? If so How does it Load into Snowflake ! Can anyone throw some light on this? Matillion ETL	2	1	February 1, 2022
Hi Guys, One of the columns in my grid variable is Datetime format. I get the current timestamp using select current_timestamp(). Then I use a fixed flow component and output to a table in snowflake Matillion ETL	1	0	January 11, 2022
How to keep snowflake function as is without converting to a string in a component? Matillion ETL	8	1	April 26, 2023