problem set TIMEZONE
I work on win2000 using cygwin.
gedis30=# select now();
now
--------------------------------
09/07/2002 09:33:27.156341 GMT
(1 row)
The time of windows is 11:33:27.
--
Because the time postgres is not equal to time windows ?
Bye !!
Frank Lupo (Wolf) !!
--
Prendi GRATIS l'email universale che... risparmia: http://www.email.it/f
Sponsor:
Su www.oliviero.it trovi prodotti naturali per dimagrire senza fatica.
Come l'efficace Lipo Block Set. Scoprilo qui.
Clicca qui: http://adv2.email.it/cgi-bin/foclick.cgi?mid=641&d=19-7
I work on win2000 using cygwin.
gedis30=# select now();
--------------------------------
09/07/2002 09:33:27.156341 GMT
The time of windows is 11:33:27.
Because the time postgres is not equal to time windows ?
It seems that your PostgreSQL backend does not have a time zone set
which can be interpreted by the cygwin date/time routines. You are
probably two hours away from GMT, right? Test using SET TIME ZONE within
Postgres, choosing a value or a string which is actually installed and
valid.
- Thomas