SQL Server Date Functions

This page lists the most commonly used SQL Server Date functions that allow you to handle date and time data effectively.

Returning the current date and time

FunctionDescription
CURRENT_TIMESTAMPReturns the current system date and time without the time zone part.
GETUTCDATEReturns a date part of a date as an integer number.
GETDATEReturns the current system date and time of the operating system on which the SQL Server is running.
SYSDATETIMEReturns the current system date and time with more fractional seconds precision than the GETDATE() function.
SYSUTCDATETIMEReturns the current system date and time in UTC time
SYSDATETIMEOFFSETReturns the current system date and time with the time zone.

it will helps you…

0 0 vote
Article Rating

Do you want to hire us for your Project Work? Then Contact US.
Subscribe
Notify of
guest
0 Comments
Inline Feedbacks
View all comments
0
Would love your thoughts, please comment.x
()
x