DateTime

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

bbawa1@yahoo.com - 25 Jun 2007 21:26 GMT

Hi,

I have a column of datatype DateTime. I need to retrieve data from
last 14
days old.

I am doing like this but it doesn't work.

Select reveiveddate from table1
where receiveddate = GetDate()-day(14)

Reply to this Message

David R. Longnecker - 25 Jun 2007 22:30 GMT

bbawa1-

I'm assuming you're quering SQL rather than a .NET data object. In either
case, give this a try:

SELECT ReceivedDate FROM Table1
WHERE ReceivedDate = GetDate() - 14

Since the base unit in SQL Server is day, the -14 should be just fine.

I suppose you could also get explicit with:

SELECT ReceivedDate FROM Table1
WHERE ReceivedDate = DATEADD(d, -14, GetDate())

The d parameter of DATEADD specifies you're working with days.

-dl

--
David R. Longnecker
http://blog.tiredstudent.com

> Hi,
>
[quoted text clipped - 5 lines]
> Select reveiveddate from table1
> where receiveddate = GetDate()-day(14)

Reply to this Message

Free Magazines

Get these publications absolutely FREE for up to 12 months. There are no hidden fees and no obligation. Simply choose a title, complete the application form and submit it. Read more ...