| 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? |
| Content-Type: | multipart/alternative;
|
|---|
Hi there:
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.
Meifen Xu
* (484) 344 4622
* meifen_xu@merck.com
[text/html]
|