SQL Server Date datename getdate function

SQL Server Date datename getdate function

GetDate () Function instance

You can call the use of the GETDATE () function in SQL Server 2005 's user customization function (udfs:user Defined functions), which is an example of the following example:

--Create a UDF now ()

CREATE FUNCTION Dbo.now ()

RETURNS DATETIME

As

BEGIN

Return (GETDATE ());

End;

Go

--Test to see if there really is a success

SELECT Dbo.now ();

Go

--Now that the test has been successful, you can remove

DROP FUNCTION Dbo.now;

Go

Datename function

The main use of the Datename function is to extract the specified part of the data from the date, such as the year we want in the current date, the month, and so on. The return type is nvarchar.

The specific syntax is as follows:

Datename (param,date);

Param is the parameter that specifies the part of the date to return, including the following:
Date part abbreviation

Year

YY, yyyy

Quarter

QQ, Q

Month

MM, M

DayOfYear

Dy, y

Day

DD, D

Week

WK, WW

Weekday

Dw

Hour

hh

Minute

MI, n

Second

SS, S

Millisecond

Ms

Date is the specified day.

Example:

Select Datename (Year,getdate ()) as ' year '

Executing the SQL statement above will see the return value of ' 2006 '

The table below lists the most important built-in date functions in SQL Server: function description
GETDATE () returns the current date and time
DATEPART () returns a separate part of a date/time
DATEADD () Add or subtract a specified time interval from a date
DATEDIFF () returns the time between two dates
CONVERT () Displays the date/time in a different format

SQL Date Data type
MySQL stores date or date/time values in the database tutorial using the following data types:
DATE-Format YYYY-MM-DD
DATETIME-format: Yyyy-mm-dd HH:MM:SS
TIMESTAMP-format: Yyyy-mm-dd HH:MM:SS
Year-format YYYY or YY
SQL Server stores date or date/time values in the database using the following data types:
DATE-Format YYYY-MM-DD
DATETIME-format: Yyyy-mm-dd HH:MM:SS
smalldatetime-format: Yyyy-mm-dd HH:MM:SS
TIMESTAMP-Format: Unique number