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
SAS side.

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?
>
>
>Thanks