working with date variables

[TheStandard]

Is it possible to initialize a variable of type date in a PL/SQL block to one week from today?

Is it even possible to initialize a date variable to the current date without explicitly specifying the current date?

 

[SantaMufasa]

Stan,

declare
    dt date := sysdate;
begin
    dbms_output.put_line('Today is '||dt);
end;
/

Today is 20-MAY-05

PL/SQL procedure successfully completed.

I am not sure I understand what you are trying to ask here:

Is it even possible to initialize a date variable to the current date without explicitly specifying the current date?

What are you trying to avoid and what would you like to see?

Mufasa
(aka Dave of Sandy, Utah, USA)

http://www.dasages.com

Do you use Oracle and live or work in Utah, USA?
Then click here to join Utah Oracle Users Group on Tek-Tips.

 

[TheStandard]

Oh, sorry, I didn't realize you could do that.

sysdate isn't in the index of the book I'm using?

What book would you recommend for PL/SQL?

 

[SantaMufasa]

If you go out to Amazon.com and query for "PL/SQL", the titles of the books will generally give guidance as to the most appropriate for your needs. I have found that the "Oracle Press" series of books (not affiliated with Oracle Corporation) is a safe bet.

Mufasa
(aka Dave of Sandy, Utah, USA)

http://www.dasages.com

Do you use Oracle and live or work in Utah, USA?
Then click here to join Utah Oracle Users Group on Tek-Tips.