To cut a date in PostgreSql?

Question

To cut a date in PostgreSql?

In the sql query using SELECT date_trunc('day', table.created) AS day .... next, the request.
as a result I receive date in the form 2016-03-28 00:00:00.000000 , how do I request to cut this date to mind 2016-03-28?

PostgreSQL

Elmo.Marquar asked July 12th 19 at 17:06

Related questions

More answers about "To cut a date in PostgreSql?"

1 answer

Elmo.Marquar answered on · Accepted Answer · 2019-07-12T17:08:51.430Z

Elmo.Marquar answered on July 12th 19 at 17:08

Solution

Just need instead of date_trunc('day', table.created) to put the day(table.created)