> -----Original Message----- > From: Kevin Grittner [mailto:[EMAIL PROTECTED] > Sent: Thursday, January 31, 2008 12:33 PM > To: Roberts, Jon; pgsql-hackers@postgresql.org > Subject: RE: [HACKERS] timestamp format bug > > >>> On Thu, Jan 31, 2008 at 12:28 PM, in message > <[EMAIL PROTECTED]>, > "Roberts, > Jon" <[EMAIL PROTECTED]> wrote: > > The default timestamp format appears to be yyyy-mm-dd hh24:mi:ss.ms > > Not to me: > > select now(); > now > ------------------------------- > 2008-01-31 12:31:40.568746-06 > (1 row) >
I'm guessing that is a server setting on how to format a timestamp. Your appears to be yyyy-mm-dd hh24:mi:ss.us. So on your db, run this query: select sub.t1, to_char(t1, 'yyyy-mm-dd hh24:mi:ss.us') as char_t1 from ( select timestamp'2008-01-31 12:31:40.500000' as t1 ) sub I bet you get this: "2008-01-31 12:31:40.50";"2008-01-31 12:31:40.500000" Don't you think it should have two identical columns? Secondly, this link shows that ms should be 000-999 and us should be 000000-999999. http://www.postgresql.org/docs/8.2/static/functions-formatting.html All of the other fields are padded like month, day, year, hour, minute, and second and are consistent. The formats ms and us should be consistent too. Jon ---------------------------(end of broadcast)--------------------------- TIP 2: Don't 'kill -9' the postmaster
