Posted by Igor on 11/08/06 10:48

markc600@hotmail.com wrote:
> select *
> from mytable
> where datediff(day,getdate(),col)=0 and col <= getdate()

I forgot that i posted this :), thanks for your reply.

• Next in forum: Re: Copy databases from SQL 2005 server to SQL Express
• Prev in forum: ISQL: Msg 170, Level 15, State 1, Line 1 Line 1: Incorrect syntax near ' '
• Thread view: Re: SQL query filtering date field by today's date?

[Reply to this message]