Home » SQL & PL/SQL » SQL & PL/SQL » Date problem
Date problem [message #36044] Thu, 01 November 2001 02:33 Go to next message
Messages: 6
Registered: November 2001
Junior Member
I want to insert in my database the following :
12/10/2001 10:12:00AM
12/10/3001 10:12:00AM

So when I insert this value I write:
INSERT INTO my_table(my_date)
VALUES ( TO_DATE(' 12/02/2001 10:12:00AM', 'DD/MM/YYYY HH:MI:SSAM') );

INSERT INTO my_table(my_date)
VALUES ( TO_DATE(' 12/02/3001 10:12:00AM', 'DD/MM/YYYY HH:MI:SSAM') );

But when I perform the: Select * from my_table;
appers the following:
A. 12-FEB-01 and not the full 12-FEB-01 10:12:00AM (the hour, minute, sec information did not appear)
B. I could not distinguish the difference between years 2001,3001 because the result of the selection comes as 12-FEB-01 so I do not know when I refer to 2001 or 3001
Any idea what can I do to solve the problem?
I have problems continuing my work due to that problem...
Thank you a lot in advance!

Re: Date problem [message #36045 is a reply to message #36044] Thu, 01 November 2001 03:07 Go to previous message
Messages: 18
Registered: December 2000
Junior Member
Type the following before issuing your select statement.


Previous Topic: date
Next Topic: Running SQL script/file
Goto Forum:

Current Time: Mon May 20 03:46:24 CDT 2024