Home » Developer & Programmer » Forms » converting varchar to time
converting varchar to time [message #80434] Thu, 19 September 2002 23:45 Go to next message
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?
Re: converting varchar to time [message #80437 is a reply to message #80434] Fri, 20 September 2002 11:41 Go to previous message
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: Sat Mar 02 11:39:13 CST 2024