Re: Dates

From: Roger Smith <rsmith22_at_fastmail.net>
Date: Tue, 21 Oct 2003 21:25:23 GMT
Message-ID: <7vhlb.30689$At.26781@edtnps84>

That worked perfectly, how do you increment months to a date.

select (LastDate + [5 months]) as DueDate from....

I appreciate the help.

"J Alex" <nospam_at_nospamx.info> wrote in message news:9Cglb.49022$mp1.5911_at_nwrddc02.gnilink.net...
>
> "Roger Smith" <rsmith22_at_fastmail.net> wrote
> > I need to physicaly change a date to the first of every month ex:
> >
> > 12/31/2000 to 12/1/2000 and so on
> >
> > select RealDate, (Changed RealDate) as NewDate
> > from ...
> >
> SELECT TRUNC(date_item,'MONTH') from table_name;
>
>
Received on Tue Oct 21 2003 - 16:25:23 CDT