NT Oracle7.2 - dates problem

From: Andy Hardy <aph_at_ahardy.demon.co.uk>
Date: 1997/06/23
Message-ID: <tLbPWDAhzrrzEw5Y@ahardy.demon.co.uk>#1/1

Hi,

I'm perplexed about the following problem where I'm inserting a system date into a table:

insert into my_table (status_date) values (select sysdate from dual);

select to_char(status_date, 'HH24:MI:SS') from my_table;

The sysdate is 16:45, but the retrieval from my_table shows it to be 04:45 - i.e. I'm consistently getting values which are out by 12 hours.

What's happening?

and how do I stop it...

Andy
Andy Hardy. PGP key available on request

Received on Mon Jun 23 1997 - 00:00:00 CDT