use like with timestamp in postgresql code example Example: ilike for date postgres column::text LIKE '2011-01-%'