Re: 24 hour clock problem

Are you sure about this ?

Look at the following:

SQL> insert into test values (to_date('28.03.2003 14:43:10','DD.MM.RRRR HH24:MI:SS'));
1 row created.

SQL> select to_char(test,'DD.MM.RRRR HH24:MI:SS') from test; TO_CHAR(TEST,'DD.MM

It works just fine

//tc

"Thomas Hough" <thomas.hough_at_dn.no> wrote in message news:b61l9q$cnt$1_at_oslo-nntp.eunet.no...
> Hi there,
>
> I'm something of a newbie when it comes to Oracle so I must apologize if
> this is a stupid question.
>
> I have a table with a date field into which I want to insert a date and
> time,
> the date format in my insert statement is like this: to_date('28.03.2003
> 14:43:10', 'DD.MM.RRRR HH24:MI:SS')
>
> I expected this to give me the time in 24 hour clock format, but the value
> for the time gets set to 02:43:10 PM, is there any way to get Oracle to
> store it as 14:43:10?
>
> Reghards
> Thomas
>
>
Received on Fri Mar 28 2003 - 17:21:10 CET