I have two dates. One I get from the database, the other is which one I want to pass. How can I check if these two are the same? These are timestamp with time zones
In this case they are the same.
x
% timestamp_coloumn is my column where the value is in it
SELECT *
FROM public.tbl_text
WHERE ('2021-06-02T06:33:51.485Z' - timestamp_coloumn) = 0;
%What I hand over: 2021-06-02T06:33:51.485Z
%Stands in the database: 2021-06-02 06:33:51.485093+00 = timestamp_coloumn
Advertisement
Answer
SELECT *
FROM public.tbl_text
WHERE
'2021-06-02T06:33:51.485Z'::timestamptz =
date_trunc('milliseconds', timestamp_coloumn);