Re: now()
"Magnus Hagander" <[email protected]>
| Newsgroups | gmane.comp.db.postgresql.devel.win32 |
|---|---|
| Message-ID | <[email protected]> |
What does SHOW timezone show? Has it picked up the correct timezone? If not, try setting the timezone in postgresql.conf and restart the database. //Magnus > -----Original Message----- > From: Yuri B. Lukyanov [mailto:[email protected]] > Sent: Wednesday, July 28, 2004 1:30 PM > To: [email protected] > Subject: [pgsql-hackers-win32] now() > > sorry for my english. > > I have a problem with date/time function now(). > When I run "SELECT now()" query, I get result less than local > system time (localtime - 1 hour). I understand it concerned > with daylight-saving, but I cann't understand why postgresql > take no account of it. > > > ___________________________________ > Best regards, Yuri B. Lukyanov > 28 июля 2004 г. 15:15:03 > mailto:[email protected] > > > ---------------------------(end of > broadcast)--------------------------- > TIP 5: Have you checked our extensive FAQ? > > http://www.postgresql.org/docs/faqs/FAQ.html > > ---------------------------(end of broadcast)--------------------------- TIP 1: subscribe and unsubscribe commands go to [email protected]