Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: date parts
John Duran <d3plan_at_hotmail.com> wrote in message news: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
select to_char(sysdate, '"7"dddhh24mi') from dual; Received on Sat Nov 20 1999 - 09:58:52 CST