select '20:00:00'::time +
interval '4 hours' =
'00:00:00'::time
select '20:00:00'::time +
interval '4 hours' =
'00:00:00'::time
select current_date = date '2023-12-20'
select current_date = date '2023-12-20'
select current_time > time '23:59:59'
select current_time > time '23:59:59'
select age(timestamp '2023-12-20', timestamp '2023-01-01') > interval '1 year'
select age(timestamp '2023-12-20', timestamp '2023-01-01') > interval '1 year'
select extract(hour from current_timestamp) between 0 and 23
select extract(hour from current_timestamp) between 0 and 23
select '2023-12-20 15:00:00'::timestamp with time zone
at time zone 'UTC' = '2023-12-20 15:00:00+00'
select '2023-12-20 15:00:00'::timestamp with time zone
at time zone 'UTC' = '2023-12-20 15:00:00+00'
select interval '1 day' = interval '24 hours'
select interval '1 day' = interval '24 hours'
select current_timestamp at time zone 'Asia/Tokyo'
> current_timestamp at time zone 'Asia/Kolkata'
select current_timestamp at time zone 'Asia/Tokyo'
> current_timestamp at time zone 'Asia/Kolkata'
select '2023-12-31'::date - '2023-01-01'::date = 365
select '2023-12-31'::date - '2023-01-01'::date = 365
select extract(dow from current_date) between 0 and 6
select extract(dow from current_date) between 0 and 6
select current_timestamp is not distinct from now()
select current_timestamp is not distinct from now()
select age(timestamp with time zone '2023-12-20 12:00:00-05',
timestamp with time zone '2023-12-20 17:00:00+00') = interval '0 seconds'
select age(timestamp with time zone '2023-12-20 12:00:00-05',
timestamp with time zone '2023-12-20 17:00:00+00') = interval '0 seconds'
select current_date + interval '1 month' - interval '30 days' != current_date
select current_date + interval '1 month' - interval '30 days' != current_date
select '24:00:00'::time is not null
select '24:00:00'::time is not null
select timezone('PST', now()) < timezone('EST', now())
select timezone('PST', now()) < timezone('EST', now())
select extract(epoch from interval '1 hour') = 3600
select extract(epoch from interval '1 hour') = 3600
select current_date - interval '1 year' < '2022-12-20'::date
select current_date - interval '1 year' < '2022-12-20'::date
select '2023-01-01 12:00:00'::timestamp without time zone
at time zone 'UTC' = '2023-01-01 12:00:00+00'
select '2023-01-01 12:00:00'::timestamp without time zone
at time zone 'UTC' = '2023-01-01 12:00:00+00'
select interval '1 day' * 2 = interval '48 hours'
select interval '1 day' * 2 = interval '48 hours'