Can supabase order timestamp with timezone?
Hello everyone, I tried to make an ordering rule to my supabase query but it's not working as expected.
I am using the timestamp with timezone format
2024-09-13 23:39:43.148866+00 to store the date.
Is is possible to order query.order('send_at', { ascending: true }); a timestamp column?7 Replies
What does not working as expected mean?
What is your whole query?
It just mean that things are not ordered, rest are working
Ordering works on a timestamp column
Specifically, a
TIMESTAMP WITH TIMEZONE column.timestamptz works.
That's just an alias, but yes.
Well at least for me as a single user...