postgres sql, date_trunc without extra zeroes
date, date-format, postgresql, sql
Solution
please, try
SELECT date_trunc(...)::date;
Problem
This is an excerpt from my sql query ``` SELECT date_trunc( 'day', to_timestamp(requests.date_created) )AS DAY, ``` this is my output `2013-02-04 00:00:00+00` I want this to be just `2013-02-04` how do I get the desired result?