Trim date in PostgreSql?

Question

PostgreSQL

In sql query I use SELECT date_trunc('day', table.created) AS day and .... further query.
as a result, I get the date in the form 2016-03-28 00:00:00.000000 , how can I cut this date in the query to look like 2016-03-28?

Answer 1

You just need to put day(table.created) instead of date_trunc('day', table.created)