DateTime Query

[Reynet01]

I Know this is simple but how would I lookup records in a Datetime field that would only show me records for todays date.

If knowledge were power I would be a AAA battery!

 

[gjsaturday]

have you tried...

select * from yourtable
where date = CONVERT(VARCHAR,(GETDATE()),101)

 

[Reynet01]

The problem is the field is datetime and basically I have tried

[DateofOrder]=Date() but I still get no records

If knowledge were power I would be a AAA battery!

 

[gjsaturday]

how about

where convert((varchar,(dateoforder),101) = CONVERT(VARCHAR,(GETDATE()),101)

getdate() gets today's date.

 

[donutman]

SQL Alert bumped up to condition Orange.
-Karl

[red] Cursors, triggers, user-defined functions and dynamic SQL are an axis of evil![/red]
[green]Life's uncertain...eat dessert first...www.deerfieldbakery.com[/green]

 

[r937]

karl, what does that mean?

where DateofOrder
= dateadd(d,datediff(d,0,getdate()),0)



rudy | r937.com | Ask the Expert | Premium SQL Articles
SQL for Database-Driven Web Sites (next course starts March 6 2005)

 

[donutman]

Just a nod to vongrunt, re thread183-1005313.
-Karl

[red] Cursors, triggers, user-defined functions and dynamic SQL are an axis of evil![/red]
[green]Life's uncertain...eat dessert first...www.deerfieldbakery.com[/green]

 

[JamesLean]

;-)

Reynet01, that post will also answer your question.

--James