« GCC == Green Cheek Conure
Joy »
h1

MS SQL Server Transact-SQL NOW() Function

February 16th, 2008

Recently, I was searching around for how to obtain the current day’s datetime using a SQL query in SQL Server Management studio. I know I had obtained this value from MySQL with NOW() function, but could find nothing of the sort for Microsoft’s SQL Server. After digging around in MSDN Library, I found this:

http://msdn2.microsoft.com/en-us/library/ms188383.aspx

SELECT GETDATE();

Hopefully this post will allow others searching like I did to find what they are looking for quicker.

2 comments to “MS SQL Server Transact-SQL NOW() Function”

  1. You really did help me to get it quicker :)
    Thanks :)

         by Lond February 27th, 2008 at 12:09 pm

  2. […] Solution via The Matt Faus Blog […]

         by JeffreyBarke.net » Blog Archive » When NOW() is GETDATE() July 14th, 2008 at 11:24 pm

Leave a Comment