Discard millisecond part from timestamp

Question

How can I discard/round the `millisecond` part, better if the `second` part is also removed from a `timestamp` w/o `timezone` ?

Accepted Answer

A cast to `timestamp(0)` or `timestamptz(0)` rounds to full seconds:

```
SELECT now()::timestamp(0);
```

Fractions are not stored in table columns of this type.

`date_trunc()` truncates (leaves seconds unchanged) - which is often what you really want:

```
SELECT date_trunc('second', now()::timestamp);
```

Solution