SQL query filtering date field by today's date?

#1

Can someone tell me sql query for filtering date field for current day,
not last 24hours but from 00:00 to current time?

#2

select *
from mytable
where datediff(day,getdate(),col)=0 and col <= getdate()

#3

markc600 (AT) hotmail (DOT) com wrote:

Quote:

select *
from mytable
where datediff(day,getdate(),col)=0 and col <= getdate()

I forgot that i posted this

, thanks for your reply.

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

comp.databases.ms-sqlserver comp.databases.ms-sqlserver