postgres query timestamp by date code example

Example 1: postgres get timestamp

SELECT CURRENT_TIMESTAMP;

Example 2: psql datetime grather than

SELECT *
FROM table
WHERE update_date >= '2013-05-03'::date
AND update_date < ('2013-05-03'::date + '1 day'::interval);

Example 3: ilike for date postgres

column::text LIKE '2011-01-%'

Example 4: postgresql get date from datetime

SELECT DATE(column_name) FROM table_name;