Re: ProC question

This really isn't a big deal unless you're talking about converting the date into a binary date. Pro*C programs read dates just like text columns.

Try...

exec sql begin declare section;
  varchar my_date[20];
exec sql end declare section;

main()
{

.
.
.

   exec sql select sysdate

            into   :my_date
            from   dual;

    -or-

    exec sql select to_char(sysdate, 'mm/dd/yyyy hh24:mi:ss')

             into   :my_date
             from   dual;

Will.

-- 
======================================================================
Will Kooiman                        Computer Systems Authority
Systems Consultant                  6380 LBJ Freeway, Suite 181
(972) 960-0180 x236                 Dallas, TX 75240
mailto:wkooiman@csac.com            http://www.csac.com