From: Austin Moseley <\"moseba@audv55.aud.alcatel.com'>
Subject: Re: Oracle DATE problem
Date: 1996/04/04
Message-ID: <4k1kc3$9ok@news01.aud.alcatel.com>#1/1
references: <4j5e8b$16re@news.missouri.edu> <4j9sfb$l1@tribune.concentric.net>
content-type: text/plain; charset=us-ascii
organization: Myself
mime-version: 1.0
newsgroups: comp.databases.oracle
x-mailer: Mozilla 1.1N (Windows; I; 16bit)


Ken Denny <kedenny@mail.concentric.net> wrote:
>
>>char dat[30];
>>
>>EXEC SQL
>>  SELECT SYSDATE INTO :dat FROM DUAL;
>>
>>and I also tried 
>>
>>EXEC SQL
>>  SELECT TO_CHAR(SYSDATE,'DD/MM/YY HH24:MI:SS') INTO :dat FROM DUAL;
>

Declare the host variable to the precompiler. 

EXEC SQL BEGIN DECLARE SECTION;

 char the_date[30];

EXEC SQL END DECLARE SECTION;

EXEC SQL SELECT TO_CHAR(...) INTO :the_date FROM DUAL;


-Austin