GitHub

sql: support datetime functions make_date, make_timestamp, date_trunc

Previously, `make_date`, `make_timestamp`, and `make_timestamptz` built-ins were not implemented. In addition, a new signature for `date_trunc` was not implemented. This was inadequate because it ...
GitHub

Wrong result on equality between Date and Timestamp given as query parameter

We discovered a wrong result returned by the equality operator when comparing a date and a timestamp when the date operand is explicitly casted, but not the timestamp: import java.sql.Connection; ...
Ars Technica

SQL help with timestamp and between

SELECT class,time_stamp FROM cf_status_log WHERE class like 'any' AND ( time_stamp BETWEEN now() AND ( timestamp with time zone '2013-12-22 17:33:25-0500' - interval '60' minute ) ) order by class ...