|
|
Posted by John on 10/02/09 11:45
"Tom Moreau" <tom@dont.spam.me.cips.ca> wrote in message
news:4Sd1g.5357$wK1.227431@news20.bellglobal.com...
> Try:
>
> WHERE hit_date >= GETDATE() - 2
>
>
> --
> Tom
Yes. That's it.
Thanks!
JB
>
> ----------------------------------------------------
> Thomas A. Moreau, BSc, PhD, MCSE, MCDBA
> SQL Server MVP
> Toronto, ON Canada
> .
> "John" <nothanks@nope.com> wrote in message
> news:7JKdnbE0F6Nc-tjZRVn-uQ@adelphia.com...
> Hi Everyone,
>
> I use the following to get records from the last two days in MySql:
> where date_entered <= curdate() and date_entered >=
> DATE_SUB(curdate(),INTERVAL 2 day)
>
> I'm looking to do the same in MS-Sql server but I'm just not getting it.
> I've got this so far which does not work:
> where hit_date <= GETDATE() and hit_date >= DATE_SUB(GETDATE(),INTERVAL
> 2
> day)
>
> then I tried this:
> WHERE hit_date >= DATEDIFF(GETDATE(), (GETDATE()-2)>
>
> Essentially, I need all records from the last two days.
>
> Any help or guidance in this matter would be greatly appreciated.
>
> -JohnyB
>
>
Navigation:
[Reply to this message]
|