Thread: 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