Microsoft SQL - get time

[Nicolas Tolksdorf]

Is there a Microsoft SQL query which returns the present datetime.
Pseudo-code eg. select * from table1 where date > getTime(now)
Is there a MS SQL specific equivalent to 'gettime(now)'?

[Rick Valdez]

There is a getdate() function in T-SQL (Microsoft's SQL syntax used in SQL Server).
Just be aware that if you put getdate() in your WHERE clause, you might not get any results as it searches for a datetime stamp.
You can use a LEFT(getdate(), 11) in your WHERE clause and will return something like this...
Jul 24 2003

[Nicolas Tolksdorf]

Cheers for you help.