Today in SQL

[ASH]

Hello,

I wanna to extract today by SQL . what is SQL statment for Today

like " Selcet * from orders where Date = """Today""" "


Regards,,,

 

[fpineda101]

For Oracle...
SELECT * FROM order
WHERE date = to_char(SYSDATE, 'MM-DD-YY')

For SQL Server...
SELECT * FROM order
WHERE date = getDate()

 

[ASH]

Thanks for answer

its dose not work with MS-ACCESS 2003

can give me code for Access ?

 

[fpineda101]

Access should be something like this...

SELECT * FROM order
WHERE date = format(Now, "MM-dd-yy")

Now is a VB variable that holds the current system date and time. You need to format it so that drops the time off the variable. I am not sure this code will work but the concept is what you are looking for.