select to_char(date, 'yyyy-mm-dd hh24:mi:ss.ms') as char,
date
from (select timestamp'2008-01-30 15:06:21.560' as date) sub
"2008-01-30 15:06:21.560";"2008-01-30 15:06:21.56"
Why does the timestamp field truncate the 0 but when I show the
timestamp as a character in the default timestamp format, it does not
truncate the trailing zero?
These two fields should be consistent because they should be formatted
the same way. I'm using versions 8.2.4 and 8.2.5 and both versions gave
me the same results.
Jon
---------------------------(end of broadcast)---------------------------
TIP 6: explain analyze is your friend
