Display of TIMESTAMP in 7.2
От | Alessio Bragadini |
---|---|
Тема | Display of TIMESTAMP in 7.2 |
Дата | |
Msg-id | 1012911566.25180.522.camel@iris обсуждение исходный текст |
Ответы |
Re: Display of TIMESTAMP in 7.2
Re: Display of TIMESTAMP in 7.2 |
Список | pgsql-hackers |
Hi all, starting with 7.2, now() returns a time with milliseconds. If extracted from the db and displayed verbatim, it shows up as '2002-02-05 10:59:36.717176+02'. Unfortunately, I have a lot of code that displays the date/time directly from the db on a web page without any to_char transformation and now that is quite harder to understand. Is there any way to have an implicit formatting back that trims the milliseconds on a per-connection variable? -- Alessio F. Bragadini alessio@albourne.com APL Financial Services http://village.albourne.com Nicosia, Cyprus phone: +357-22-755750 "It is more complicated than you think" -- The Eighth Networking Truth from RFC 1925
В списке pgsql-hackers по дате отправления: