time display

i have 2 create a databse for an assignmetn i haev created it inserted all the data, then when i was chekign the data one of the fields ios totally wrong, the time field which i thought i had set up correctly is not workng here is cone of the insert statements and its result


INSERT INTO ClientOrder
(Order#, DateOfDelivery, TimeOfDelivery, ClientID)
VALUES
('001','01-JUN-2005',TO_Date('12:00', 'HH24:MI'),'0000000004');
i want it to display the time here ^^^^^^^ but its displays it like this

ORDER# DATEOFDEL TIMEOFDEL CLIENTID
------ --- - -------- ----------
1 01-JUN-05 01-MAY-05 4

the time field is displayed as a month not as 12:00 as i would like it 2, if anyone knows how i can fix it let me know please, and to fix it i just update the fields yeh??

Hai friend

First you change the data type varchar2 to 'TimeOf Delivery' Column, and then you execute following query

INSERT INTO ClientOrder
(Order#, DateOfDelivery, TimeOfDelivery, ClientID)
VALUES
('001','01-JUN-2005','12:00','0000000004');

thanx for the help, that sounds simple enought i tried 2 do it the complicated way