insert time only

[jestin]

hi friends,

I have a problem with time oracle 8i,can anybody tell me how to insert time in oracle 8i db(for example i want to insert a time like 4:45:00 PM) if u have any solution please give me the code.

thx

[debasisdas]

u want to insert both date and time or only time ?

[jestin]

u want to insert both date and time or only time ?

i want insert time only can u help me

[jestin]

hi

i am using oracle 8i as my db, i am getting one problem while i saving time can anybody helps me in this situation.

the asp code is as follows.

[HTML]sqlinsert="INSERT INTO ACPADMIN.Tbl_RequestSched (" &_
"Rschedid, " &_
"RschedReqid, " &_
"RschedTime)values(" &_
ReplaceQuote(autonor) & ", " &_
ReplaceQuote(FKID) & ", " &_
"to_date(" & STR_Quote2(ReplaceQuote(schedSTime)) & ", 'HH24:MI:SS'))"
[/HTML]

and the schedSTime is like 16:15(24 hr format),and schedSTime is saved in the table is like as 4/1/2008 4:15:00 PM, what i want from u is that, i want to save only the time like this 4:15:00 PM without date. do u have any idea,

thx

[debasisdas]

Convert the date to this format 'DD-MM-YY HH24:MI:SS' and then insert.