Re: ProC question

Andrea Pallotta wrote:
>
> Hi everybody!!
>
> The question seems to be simple for you...
>
> In a C program with SQL calls, i have a variable to be filled with the
> content of a column. The column is a date, of course.
>
> Could you help me, with an example, to do this??
>
> Thanks in advance
>
> --
> Andrea Pallotta
> DIGITAL Italy
> Gruppo di Sviluppo ( Development Team )

Use a varchar2 variable and the to_char function to retrieve the column as a character representation of the date. Make sure the varchar2 is long enough to hold the date per the format specification.

-- 
---
Allen Kirby			AT&T ITS Production Services
akirby_at_att.com			Alpharetta, GA.