MSSQL equivalent of MySQL NOW() Function

May25

Written by:David Aldridge
5/25/2011 3:35 PM 

I was working in MSSQL recently and found myself looking for the equivalent of the MySQL now() function.

In MySQL, the following would return the current time:

select now();

The equivalent in MSSQL is :

select getdate();

So for MSSQL getdate() is the equivalent of now().

 

TrackbackPrint
Location: BlogsDavids Support Blog
Tags:

Your name:
Your email:
(Optional) Email used only to show Gravatar.
Your website:
Title:
Comment:
Security Code
Enter the code shown above in the box below
Add Comment  Cancel 
You must be logged in and have permission to create or edit a blog.