Re: [GENERAL] timestamp without time zone format

2004-06-23 Thread Richard Huxton
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 a

[GENERAL] timestamp without time zone format

2004-06-23 Thread Antony Paul
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 ? Antony Paul ---(end of broadcast)