|Date: ||Thu, 3 Jan 2002 11:28:56 -0500|
|Reply-To: ||"Xu, Meifen" <meifen_xu@MERCK.COM>|
|Sender: ||"SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>|
|From: ||"Xu, Meifen" <meifen_xu@MERCK.COM>|
|Subject: ||How to switch character format of TIME to Numeric in oracle SQL?|
Happy New Year!
I am sure that many of you may help me figure out my question here. I have a
character column of TIME(00:00:00), which I like being a SAS time format
after I extract from Oracle database directly. There functions such as
TO_NUMBER, TO_DATE. Both not apply to case.
Thank you so much.
* (484) 344 4622