Re: Oracle DATE problem
From: Austin Moseley <\"moseba_at_audv55.aud.alcatel.com'>
Date: 1996/04/04
Message-ID: <4k1kc3$9ok_at_news01.aud.alcatel.com>#1/1
Date: 1996/04/04
Message-ID: <4k1kc3$9ok_at_news01.aud.alcatel.com>#1/1
Ken Denny <kedenny_at_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 Received on Thu Apr 04 1996 - 00:00:00 CEST