rodchar
3/27/2007 11:15:00 PM
Thank you for the help.
"Alejandro Mesa" wrote:
> rodchar,
>
> > 2. is there a way to modify the time of a date variable?
> >
> > for example:
> >
> > 12/26/2006 3:49:01 PM
> >
> > i'd like to set 3:49:01 to 12:00:00 AM
>
> select
> dateadd(day, datediff(day, 0, getdate()), 0),
> cast( convert(char(8), getdate(), 112) as datetime)
>
> > 1. what i'd like to know is the easiest way to turn that date into the first
> > or last day of that month?
>
> declare @d datetime
>
> set @d = dateadd(day, datediff(day, 0, getdate()), 0)
>
> select
> cast(convert(varchar(6), @d, 112) + '01' as datetime) fdm,
> dateadd(day, -day(dateadd(month, 1, @d)), dateadd(month, 1, @d)) ldm
> go
>
>
> AMB
>
>
>
> "rodchar" wrote:
>
> > hey all,
> > i have a stored proc i'm working with:
> > i need to take the current date go back a certain number of months specified
> > in the parm.
> >
> > for example:
> >
> > SET @monthsDifference = DATEADD(month, -(monthsBack), GETDATE())
> >
> > which takes us to:
> >
> > 12/26/2006
> >
> > 1. what i'd like to know is the easiest way to turn that date into the first
> > or last day of that month?
> >
> > 2. is there a way to modify the time of a date variable?
> >
> > for example:
> >
> > 12/26/2006 3:49:01 PM
> >
> > i'd like to set 3:49:01 to 12:00:00 AM
> >
> > thanks,
> > rodchar
> >
> >