Re: date parts

Hi,
set heading off feedback off
column id format a8

select '7'||to_char(sysdate,'dddhh24mi') id from dual;

Suresh Bhat
Oracleguru
www.oracleguru.net

John Duran <d3plan_at_hotmail.com> wrote in article <811a4q$vbl$1_at_nnrp1.deja.com>...
> How do I obtain the following information from the system date:
> Running Oracle 8.0.5 on a Sun Sparc running Solaris 2.6
>
> The day of the year (1-365)
> The hour of the day (24 hour clock)
> The minutes
>
> I have to create a unique identifier each time I send a batch to a
> legacy system. It is an 8 digit number field. The first number is
> always "7" the next 3 digits are the day of the year, the next two
> digits are the hour (24 hour), and the last two are the minutes.
>
> 7DDDHHMM
>
> John
>
>
> Sent via Deja.com http://www.deja.com/
> Before you buy.
>
Received on Thu Nov 18 1999 - 11:14:08 CST