The database gets the time from the server.
Try:
select to_char(sysdate,'mm/dd/yyyy hh24:mi:ss') from dual;
Jim
--
Replace part of the email address: kennedy-down_with_spammers_at_attbi.com
with family. Remove the negative part, keep the minus sign. You can figure
it out.
"Jochen" <jri_at_doneware.de> wrote in message
news:9331ca31.0304230819.22f57006_at_posting.google.com...
> Hallo,
>
> in my sql statement i use the current_time parameter, but the time,
> oracle save is two hours before the realtime!
>
> the server, where oracle is running have the correct time
> (systemtime).
>
> where can i check or configure the database time?
>
> thanks,
> Jochen
Received on Wed Apr 23 2003 - 21:10:49 CDT
