getdate() problems 1

[durug]

Hi everybody!

I have this where statement in my select
where getdate() < = start_date
if getdate is the same date as start_date then this condition is not true because start_date is returned like this 2002-07-27 00:00:00.000 and getdate() is equal with
2002-07-27 05:25:00.000

How can I fix this problem. One way is to add to start_date 23 hours and 59 minutes. But what is the syntax for this?

Or is there other way so solve this?

Thanks a lot,
durug

 

[mgriffith]

if

datediff( day, start_date, getdate() ) > 1
^
can also use any date part
then you have a greater than 1 day difference between your start date and now

hope this helps mike griffith
----------------------------
mgriffith@lauren.com
mdg12@po.cwru.edu

 

[mgriffith]

you could also use the datepart(day, date_expression), datepart(month, date_expression), datepart(year, date_expression) and compare getdate() and your date, substituting each in for date_expression
or you could use the dateadd(hour, 23, date_expression) function if you wanted to do it the way you suggested

there's all kinds of neat date functinos

i have a listing of all sorts of useful functions that i printed out from

http://www.oreilly.com/catalog/sqlnut/chapter/ch04.html

check them out [although they did leave some useful string functions out like replace(char_to_find, which_string, char_to_replace_with) and substring(string, start_index, stop_index) out]

mike griffith
----------------------------
mgriffith@lauren.com
mdg12@po.cwru.edu