insert current time in sql procedure

Question

1.20/5 (2 votes)

See more:

SQL-Server-2014

how to insert current time in procedure through the procedure?

Posted 23-Apr-15 7:35am

Bobby Garikipati

Add a Solution

Comments

Homero Rivera 23-Apr-15 13:47pm

use getdate() which returns the current date and time, try "select getdate()" to see example

Maciej Los 23-Apr-15 15:00pm

Wha t have you tried till now?

1 solution

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Abhinav S · Answer 1 · 2015-04-23T08:16:00

Solution 1

Use the SYSDATETIME() function[^].

E.g. SELECT CONVERT (time, SYSDATETIME())

Posted 23-Apr-15 8:16am

Abhinav S

Comments

Richard Deeming 23-Apr-15 16:10pm

NB: That returns the current time for the server's current time-zone and DST settings. It's almost always better to store times in UTC (SYSUTCDATETIME[^]) and convert them to the user's time-zone when displaying them.

Alternatively, for SQL 2008 or higher, store the times using the datetimeoffset type[^], and the SYSDATETIMEOFFSET function[^].