Date: Mon, 17 May 2004 16:09:58 -0400
Reply-To: Howard Schreier <Howard_Schreier@ITA.DOC.GOV>
Sender: "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From: Howard Schreier <Howard_Schreier@ITA.DOC.GOV>
Subject: Re: time format from oracle to SAS
I can't offer any Oracle suggestions. But perhaps it can be fixed on the
Question: Is the result you are now getting passed to SAS as a datetime
numeric or as a character string?
Question: Do you want to round your values to nearest minute, or merely
*display* rounded values?
Possibly relevant: TIMEPART and INTNX functions, HHMMw.d format.
On Fri, 14 May 2004 11:42:41 -0700, NetComm888 <netcomm888@YAHOO.COM> wrote:
>I'm trying to extract some data from the oracle database. But I have
>some trouble with the time format.
>In the oracle database, the transaction time has the type of VARCHAR2
>with length of 4. But I want to display the time in SAS dataset as
>HH:MM format, like 06:50. So I used "to_date(trans_time, 'HH24:MI')".
>But this oracle function also gives the date, second, and also AM/PM.
>I really don't need those. The only thing I need is the time. So what
>function should I use?