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