CODEWITHSUNDEEP
sqlpostgresql
e1s
e1s

Reputation: 375

PostgreSQL show milliseconds in time type

Why when I select time type show only hours, minutes and second but not milliseconds like in SQL Server? I try use precision in time type like time(6) but it is not work. And what mean this precision in time type if it not for store milliseconds?

select now()::time(6)

returns

10:23:00

Upvotes: 0

Views: 946

Answers (1)

jian
jian

Reputation: 4877

show only hours, minutes and second:

select now() ::time(0);

show time info at maximum precision:

select now() ::time(6);

show time info at Millisecond level.

select now() ::time(3);

Upvotes: 1

Related Questions