How to use date_trunc in PostgreSQL to truncate to 100 milliseconds?

Question

How to use date_trunc in PostgreSQL to truncate to 100 milliseconds?

The function date_trunc

uses a millisecond or second field, but the millisecond is too small for me and the second is too large. I want something in between 100 milliseconds (1/10 of a second).

How can I achieve this in PostgreSQL?

+3

sql postgresql

Hello lad 26 oct. 14 at 20:10

source to share

1 answer

Gordon linoff · Answer 1 · 2014-10-26T20:19:27+0000

I think you can do it with conversion. The following should give you tenths of a second:

select cast(datecol as timestamp(1))

How to use date_trunc in PostgreSQL to truncate to 100 milliseconds?

More articles: