Re: Newbie Date Problems

Thanks for the help... I checked the formatting functions section and it 
helped a lot.

update clients set date_raw = to_char(timestamp (date_year || '-' ||
date_month || '-' || date_day), 'YYYY-MM-DD') where clients_id='835';

That seems to work...

John

On Thu, 9 May 2002, Josh Berkus wrote:

> John,
> 
> > update table set date_iso = (date_year || '-' || date_month || '-' ||
> > date_day) where table_id='838
> 
> You'll appreciate the fix, which takes less time to write than you took
> to write your question:
> 
> You need to use the to_char function to format your date fragments as
> strings with the proper number of digits:
> 
> ltrim(to_char(date_month, '00'))
> 
> See "formatting functions" in the docs (under "functions and
> operators") for more help.
> 
> -Josh Berkus
>