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 5 27415
Try:
WHERE hit_date >= GETDATE() - 2
--
Tom
----------------------------------------------------
Thomas A. Moreau, BSc, PhD, MCSE, MCDBA
SQL Server MVP
Toronto, ON Canada
..
"John" <no******@nope.com> wrote in message
news:7J********************@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
"Tom Moreau" <to*@dont.spam.me.cips.ca> wrote in message
news:4S*******************@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" <no******@nope.com> wrote in message news:7J********************@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
Use the dateadd (Or Datediff) for that:
hit_date >= DATEADD(d,-2,GETDATE()), keep in mind that this will
substract the days including the current time, so a 04/19/2006 1:09
will result in 04/17/2006 1:09.
HTH, Jens Suessmeyer.
--- http://www.sqlserver2005.de
---
John (no******@nope.com) writes: 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.
Since you appear to be trying out syntax at random, I must ask: did
you ever consider to consult Books Online?
--
Erland Sommarskog, SQL Server MVP, es****@sommarskog.se
Books Online for SQL Server 2005 at http://www.microsoft.com/technet/pro...ads/books.mspx
Books Online for SQL Server 2000 at http://www.microsoft.com/sql/prodinf...ons/books.mspx
Do you mean yesterday and today's data only?
Select * from yourtable
where datecol>=Dateadd(day,datediff(day,o,getdate()),-1)
Madhivanan This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics
by: Jaycee66 |
last post by:
I am new to MS Access 2000 and I am trying to create a report that
would produce the last seven/any number days of data input through a
form?
In addition, recommendations of any good Access...
|
by: BLUE WATER |
last post by:
Help,
When I am finished entering in data into my form A, I press the save button
that
saves this new data to a new record. However I would like my other form to
open at a specific record, the...
|
by: A_M_IS |
last post by:
Hello group,
hope to anybodys help on my temporary blackout.
(Using Access 2003 on XP Win.)
I know how to create and edit temporary query recordset, then I can set
this data source as my form...
|
by: lorirobn |
last post by:
Hi,
I have a report that has a query as its record source.
The query picks up records from a table that meet certain criterion.
The report then counts how many records there are for each key...
|
by: Sector 7G |
last post by:
I'm working with a SQL query for a Human Resources database. Its intended purpose is to find all the paycheck records with a check date (prckhist.chkdate ) more recent than eleven days past the...
|
by: wvmbark |
last post by:
First time poster... I just found this forum and it appears there's plenty of people here that could make short work of problem that's been driving me absolutely bonkers for months.
Every day we...
|
by: AllyFrog |
last post by:
Hello,
I have a database which manages bookings for casual staff. When bookings are for just one day, then they can be entered as a new record into a form. Frequently however, a booking may be...
|
by: daniel aristidou |
last post by:
Hi can anyone help me with the logic of updating records that are selected in a datagrid. Just wanna be sure before i code it all, since its first time im doing this and making sure the logic is...
|
by: Dr Al |
last post by:
I have a table with four date fields, some of which may not be filled
in based on our data entry needs. I have a criteria set as <date()-180
which is supposed to pull dates older than 180 days ago....
|
by: DolphinDB |
last post by:
Tired of spending countless mintues downsampling your data? Look no further!
In this article, you’ll learn how to efficiently downsample 6.48 billion high-frequency records to 61 million...
|
by: ryjfgjl |
last post by:
ExcelToDatabase: batch import excel into database automatically...
|
by: isladogs |
last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM).
In this month's session, we are pleased to welcome back...
|
by: isladogs |
last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM).
In this month's session, we are pleased to welcome back...
|
by: Vimpel783 |
last post by:
Hello!
Guys, I found this code on the Internet, but I need to modify it a little. It works well, the problem is this: Data is sent from only one cell, in this case B5, but it is necessary that data...
|
by: jfyes |
last post by:
As a hardware engineer, after seeing that CEIWEI recently released a new tool for Modbus RTU Over TCP/UDP filtering and monitoring, I actively went to its official website to take a look. It turned...
|
by: CloudSolutions |
last post by:
Introduction:
For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...
|
by: Defcon1945 |
last post by:
I'm trying to learn Python using Pycharm but import shutil doesn't work
|
by: af34tf |
last post by:
Hi Guys, I have a domain whose name is BytesLimited.com, and I want to sell it. Does anyone know about platforms that allow me to list my domain in auction for free. Thank you
| |