If you want the date why not use    SELECT SYSDATE FROM DUAL; ?

Here's a little example on using current_date though :

Command> create procedure test is

       > begin

       > dbms_output.put_line( current_date );

       > end;

       > /

Procedure created.

Command> set serveroutput on;

Command>  exec test;

2013-09-26 10:27:51

Hope that helps.

Steve

I don't believe that is possible in TimesTen.

current_date is not available as an SQL function in TimesTen, unlike Oracle. It's available as a PLSQL function, which can be used in this way:

create or replace procedure test is

          dt date;

          mydt varchar2(100);

       begin

           dt := current_date;

           mydt := to_char(dt, 'HH24');

           if ((mydt >= 0) and (mydt <= 24)) then

             dbms_output.put_line(mydt);

           else

             dbms_output.put_line('FAILURE');

           end if;

         end;

Procedure created.

Command> exec test;

11