Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium


Does it has getDateTime() in MSSQL stored procedure?

Posted on 2009-02-23
Medium Priority
Last Modified: 2012-05-06

I can use getDate() to get system date in MSSQL 2005.
Can I use it to get system datetime as well?

Or, does it has a function getDateTime() to do it?

Question by:techques
  • 2
LVL 75

Accepted Solution

Anthony Perkins earned 150 total points
ID: 23718264
GETDATE() returns the current system date and time.
LVL 75

Expert Comment

by:Anthony Perkins
ID: 23729676
A "B" grade?  Can you tell me what I could have done to earn an "A" grade?

Featured Post

Free recovery tool for Microsoft Active Directory

Veeam Explorer for Microsoft Active Directory provides fast and reliable object-level recovery for Active Directory from a single-pass, agentless backup or storage snapshot — without the need to restore an entire virtual machine or use third-party tools.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

by Mark Wills Attending one of Rob Farley's seminars the other day, I heard the phrase "The Accidental DBA" and fell in love with it. It got me thinking about the plight of the newcomer to SQL Server...  So if you are the accidental DBA, or, simp…
In this article we will get to know that how can we recover deleted data if it happens accidently. We really can recover deleted rows if we know the time when data is deleted by using the transaction log.
this video summaries big data hadoop online training demo (http://onlineitguru.com/big-data-hadoop-online-training-placement.html) , and covers basics in big data hadoop .
Enter Foreign and Special Characters Enter characters you can't find on a keyboard using its ASCII code ... and learn how to make a handy reference for yourself using Excel ~ Use these codes in any Windows application! ... whether it is a Micr…

581 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question