timestamptz format
I have searched for quite some time but I can't seem to figure it out. I can store a timestamptz with many formats and supabase will handle it and thats fine.
My main problem is I want to parse the timestamptz but I dont know the exact pattern.
Is it "%Y-%m-%d %H:%M:%S%.f%z"
Identifiers used are defined here: https://docs.rs/chrono/latest/chrono/format/strftime/index.html
It would be of great help if you could help me define it in the above defined syntax.
Here is a example of how the time was stored (this was exported via csv):
(with default value now)
id,test,timestamp
0,[],2024-01-15 21:38:27.213678+00
(with default value (now() at time zone 'utc'))
id,test,timestamp
1,[],2024-01-15 21:40:52.21653+00
//They are literally the same
I am living in germany btw.
My main problem is I want to parse the timestamptz but I dont know the exact pattern.
Is it "%Y-%m-%d %H:%M:%S%.f%z"
Identifiers used are defined here: https://docs.rs/chrono/latest/chrono/format/strftime/index.html
It would be of great help if you could help me define it in the above defined syntax.
Here is a example of how the time was stored (this was exported via csv):
(with default value now)
id,test,timestamp
0,[],2024-01-15 21:38:27.213678+00
(with default value (now() at time zone 'utc'))
id,test,timestamp
1,[],2024-01-15 21:40:52.21653+00
//They are literally the same
I am living in germany btw.
strftime/strptime-inspired date and time formatting syntax.