« 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.

13 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

  3. […] Matt Faus’s blog: MS SQL Server Transact-SQL NOW() Function […]

         by Getting the current date and time with Transact-SQL « ProgAdv January 19th, 2009 at 5:27 am

  4. Much appreciated, good Sir. Exactly what I was looking for. :-)

         by Jacob Hume January 21st, 2009 at 2:48 pm

  5. Thank you very much. Was trying to find just this.

         by Michael April 23rd, 2009 at 9:57 am

  6. Excellent find; thank you!

         by Some User April 25th, 2009 at 9:12 pm

  7. Does anyone know if there is another language or set of commands beside SQL for talking with databases?

    I’m working on a project and am doing some research thanks

         by SQL Tutorials April 30th, 2009 at 7:57 pm

  8. You know, the thing about SQL is, that there is virtually nothing that can replace it.

    Does anyone know if a substitute exists for sql? I mean besides MS SQL and Oracle and all that jazz. Thanks.

         by SQL Tutorials April 30th, 2009 at 8:37 pm

  9. Not really. Why would you want a replacement SQL is incredibly powerful.

    You might look into LINQ within .NET.

         by Matt Faus May 1st, 2009 at 9:38 am

  10. Thank you very much Matt!

         by Fedor May 4th, 2009 at 6:38 am

  11. Thanks. This was spot on.

         by Dawson L May 18th, 2009 at 10:12 am

  12. Cheers! Love it when good people such as yourselves blog these things. :)

         by Mark May 19th, 2009 at 9:32 am

  13. Thank you!!

         by Mike Ingoldby June 11th, 2009 at 3:46 pm

Leave a Comment