24 hour clock problem
From: Thomas Hough <thomas.hough_at_dn.no>
Date: Fri, 28 Mar 2003 15:13:13 +0100
Message-ID: <b61l9q$cnt$1_at_oslo-nntp.eunet.no>
Date: Fri, 28 Mar 2003 15:13:13 +0100
Message-ID: <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,
Reghards
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?