date_trunc( units, timestamp )

Truncate a date to the given precision. The precision value can be any of the following values:

"day"	"minute"	"second"	"year"

"hour"	"month"	"week"

Example

ts = date_trunc("day", ts )