timestamp without time zone format

Antony Paul wrote:

Hi all
What is the last value in a column of data type timestamp without time
zone. A sample data is 2004-06-22 18:07:00.486027. What does 486027 mean
Milliseconds or seconds since midnight or something else ?

It's fractional seconds, but your clock is unlikely to be that accurate
in reality. You can suppress the fraction by declaring a column of type
timestamp(0), or have two decimal places with timestamp(2) etc.

Same for timestamp with time zone.

--
Richard Huxton
Archonet Ltd