GetDate - Sybase, MS SQL

http://sqldud.blogspot.com/search/label/GetDate


DatePart - Get Part of the Date
-- Selecting the Current Year/Get Current Year/Separate Year Part from Date
Select DatePart(YY, GetDate()) as Current_Year
Result = INT = [2010]

-- Selecting the Current Quarter/Get Current Quarter/Separate Quarter Part from Date
Select DatePart(QQ, GetDate()) as Current_Quarter
Result = INT = [4]

-- Selecting the Current Month/Get Current Month/Separate Month Part from Date
Select DatePart(MM, GetDate()) as Current_Month
Result = INT = [10]

-- Selecting the Name of Current Month/Get Name of Current Month/Separate Month Part from Date and display its Name
Select DateName(month, GetDate()) as Current_Month_Name
Result = CHAR(30) = [October]

-- Selecting the Name of Current Month/Get Name of Current Month/Separate Month Part from Date and display its Name
Select DateName(day, GetDate()) as Current_Day
Result = CHAR(30) = [21]

-- Selecting the Name of Current Month/Get Name of Current Month/Separate Month Part from Date and display its Name
Select DateName(wk, GetDate()) as Current_Week
Result = CHAR(30) = [43]

 

Universal Time or Greenwich Meridian Time (GMT)
Getting the Universal Time - GMT

Select GetDate() as LocalTime
Result = DATETIME = [2010/10/21 오전 10:04:10]

Select GetUTCDate() as GMT_Time
Result = DATETIME = [2010/10/21 오전 1:04:10]

GetUTCDate Returns the datetime value representing the current UTC time (Coordinated Universal Time or Greenwich Mean Time)

Select DateDiff(second,GetDate(),GetUTCDate() ) as DifferenceinSec
Result = INT = [-32399]
will give you the difference between GMT and your Local Time



SELECT convert(DATE,"2010/08/23")
2010/08/23 오전 12:00:00

SELECT convert(DATETIME,"2010/10/21 13:34:56")
2010/10/21 오후 1:34:56