Timezone correction Oracle <-> Webserver

Hi! Is there a way to eliminate a given difference in time settings? I.e. the webserver runs at GMT+1, Oracle runs at GMT. I am using sysdate to produce timestamps. But the time seems to be wrong, when viewed in the webserver context. Adjusting the time on the DB server is not an option. Any hints? I know how to do it the mySQL way, but Oracle... TIA, Karsten -- Why do we have to hide from the police, daddy? Because we use emacs, son. They use vi. ----------------------------- mailto:k.dambekalns@tu-bs.de w³: http://www.k-fish.de/ gpg: http://www.k-fish.de/mykeys.gpg