PL/SQL & sysdate
From: <blank214_at_my-deja.com>
Date: 2000/06/23
Message-ID: <8ivkf1$s18$1_at_nnrp1.deja.com>#1/1
Date: 2000/06/23
Message-ID: <8ivkf1$s18$1_at_nnrp1.deja.com>#1/1
[Quoted] [Quoted] 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 Fri Jun 23 2000 - 00:00:00 CEST