date parts

From: John Duran <d3plan_at_hotmail.com>
Date: Thu, 18 Nov 1999 16:39:54 GMT
Message-ID: <811a4q$vbl$1@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 - 10:39:54 CST