Re: PL/SQL & sysdate

try this:
select to_number(to_char(sysdate, 'YYYY')) into :thisyear from dual;

Frans

blank214_at_my-deja.com heeft geschreven in bericht <8ivke8$s10$1_at_nnrp1.deja.com>...
>I want to get the current year from the database & convert it to a
>number. The PL/SQL block compiles, but hangs when I try to execute it.
>The following is the problem statement:
>
>select to_number(to_char(sysdate, 'YYYY'))
>into thisyear from dual;
>
>What am I doing wrong?
>
>Thanks in advance - Jennifer
>
>
>Sent via Deja.com http://www.deja.com/
>Before you buy.
Received on Mon Jun 26 2000 - 00:00:00 CDT