Problem with multiple records returned in query

**zealus** · Feb 4, 2009 22:25

Code:

WHERE
    LEI.CreateDateTime >= '2008-10-01' -- From the beginning time
    AND LEI.CreateDateTime  < '2008-11-01' -- To the ending time

Just a simple follow-up - wouldn't it be safer to have

Code:

WHERE
    LEI.CreateDateTime >= CAST ('2008-10-01' as datetime)
    AND LEI.CreateDateTime  < CAST('2008-11-01' as datetime)

Or it doesn't make any sense?

**r937** · Feb 4, 2009 22:41

Originally Posted by zealus

Just a simple follow-up - wouldn't it be safer to have ...

safer? how is that safer? what is the danger it is safer from?

User Tag List