SQL ignores my date range

[vcujackson]

Here is a partial statement from a query I wrote in QA for SQL server 2005

gifteffdat >='2009-07-01 00:00:000'

Our database formats the date in a datetime format. For some reason SQL is ignoring my gifteffedat. Have I formatted this incorrectly?

 

[RiverGuy]

What is the data type for gifteffedat?

 

[bborissov]

I didn't saw anything wrong in this (unless your SET DATEFORMAT is different). What is 07? Month, DAY? That is why I prefer:

gifteffdat >='20090701'

That date is NOT ambitious, it has always the same format:
YYYYMMDD.

Borislav Borissov
VFP9 SP2, SQL Server 2000/2005.

 

[tcsbiz]

That date is NOT ambitious,

I think it's a very ambitious date. It's not very ambiguous, though.

Sorry... I couldn't resist.

 

[bborissov]

You are right of course

Borislav Borissov
VFP9 SP2, SQL Server 2000/2005.