Showing posts with label select statement with the current date. Show all posts
Showing posts with label select statement with the current date. Show all posts

Wednesday, December 2, 2009

How to get the date in a sql statement (TSQL)

To get the date in a select statement, stored procedure, etc. You can use the getdate() function.
For example, you can do

Select getdate()