usage of DateValue in SQL server

[drorit30]

Hi all,

I have the following SQL statement which works on ACCESS but does not work in SQL server

SELECT * FROM [table_name] where DateValue(Now()) < table_name.required_date

required_date is a 'timedate' field which has both the date and the time.

I need the sql statment to check only the date part of the field.

SQL server does not allow the usage of DateValue like access does.

What is the correct SQL statement which will perform this?

Thank in advance,
Dror

[r937]

dror, are you going to ask us every time your query does not work the same way in sql server as it used to in access?

i think it's time you started looking these things up yourself in the sql server manual

here's one page that will help you when the time comes to display a datetime value in a particular format --

http://msdn.microsoft.com/library/de...ca-co_2f3o.asp

as for this specific "DateValue" problem, if you want rows of the table for a given date, you should select a range of datetime values like this --

where table_name.required_date >= getdate()
   and table_name.required_date < dateadd(day,1,getdate())