OraFAQ Forum: Forms » converting varchar to time

Home » Developer & Programmer » Forms » converting varchar to time

Thu, 19 September 2002 23:45

daisy
Messages: 4
Registered: May 2002

Junior Member

I save time as varchar2(5) and i want to use this data as time.How can I convert this?

Fri, 20 September 2002 11:41

Daniel R
Messages: 8
Registered: September 2002

Junior Member

write this:
V_time date;

V_time := substr(to_char(your_time_variable,'hh24:mi:ss),1,5);

Previous Topic:	send report output to text file
Next Topic:	Enable/disable submenus per user

Goto Forum:

]

Current Time: Fri Apr 19 05:43:49 CDT 2024