Hi Hans,

How about

NewDate = cast( (cast yy as char(4) || '-' || cast mm as char(2) || '-' ||
cast dd as char(2)) as date);

regards,
Sindu

On Thu, Aug 09, 2001 at 04:30:25PM -0600, hans@... wrote:
> Help,
>
> I'm drawing a blank in Server SQL
>
> Declare Variable OldDate Date;
> Declare Variable NewDate Date;
>
> Declare Variable yy Integer;
> Declare Variable mm Integer;
> Declare Variable dd Integer;
>
> yy = Extract(Year from OldDate);
> mm = Extract(Month from OldDate);
> dd = Extract(Day from OldDate);
>
> yy = yy + 1;
>
> NewDate = PutBackToGether (yy,mm,dd);
>
> What do I use for PutBackToGerher (yy,mm,dd) to get NewDate ??
>
> Best Regards
> Hans
>
>
> To unsubscribe from this group, send an email to:
> ib-support-unsubscribe@egroups.com
>
>
>
> Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/
>
>