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
---------------------------(end of broadcast)--------------------------- TIP 2: you can get off all lists at once with the unregister command (send "unregister YourEmailAddressHere" to [EMAIL PROTECTED])
