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 )