OraFAQ Forum: Server Administration » loading Julian date into a variable

Home » RDBMS Server » Server Administration » loading Julian date into a variable

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

loading Julian date into a variable [message #370450]

Sat, 25 September 1999 12:07

scott campbell
Messages: 13
Registered: July 1999

Junior Member

I'd like to load the Julian date into a variable that will be written to output files. If it can be done, please recommend the best way to do it? Thanks.

Report message to a moderator

Re: loading Julian date into a variable [message #370451 is a reply to message #370450]

Sun, 26 September 1999 07:14

Paul
Messages: 164
Registered: April 1999

Senior Member

Scott,
Here's a starting point:

select to_char(SYSDATE, 'J') from dual;

produces:

TO_CHAR
-------
2451448

so you should be able to select it INTO a
varchar2(7) variable then use the variable
as you wish. Hope this helps.

Report message to a moderator

Re: loading Julian date into a variable [message #370452 is a reply to message #370451]

Sun, 26 September 1999 10:09

scott campbell
Messages: 13
Registered: July 1999

Junior Member

Thanks a lot. Works well.

Report message to a moderator

Previous Topic:	Help on DBMS_ALERT
Next Topic:	Primary key Vs Unique+Not null

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Wed Apr 14 18:50:05 CDT 2021