Search Postgresql Archives

Timestamp with precision output format with trailing zeros

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



Hi,
# select '2022-01-06 18:00:00.000+03'::timestamptz(3);
      timestamptz
------------------------
 2022-01-06 18:00:00+03
Would it be more correct to output zero milliseconds if the column has precision defined?

Regards,
Eugene

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]

  Powered by Linux