RSS Feed

DATENAME Function Examples

DATENAME Function Examples


This DATENAME() function returns a character string that represents a part of a given date and time value. Lets see some of the examples of DATENAME() function.

DATENAME Example 1
Below queries find today's day. Result of both the queries is same:

SELECT DATENAME(dw, getdate()) AS 'Today Is'
SELECT DATENAME(weekday, getdate()) AS 'Today Is'

Result:
Today Is
Monday

DATENAME Example 2
Below queries find current week. Result of all the 3 queries is same:

SELECT DATENAME(week, getdate()) AS 'This is week'
SELECT DATENAME(wk, getdate()) AS 'This is week'
SELECT DATENAME(ww, getdate()) AS 'This is week'

Result:
This is week
30

DATENAME Example 3
Below queries find current month. Result of all the 3 queries is same:

SELECT DATENAME(month, getdate()) AS 'This is month'
SELECT DATENAME(mm, getdate()) AS 'This is month'
SELECT DATENAME(m, getdate()) AS 'This is month'

Result:
This is month
July

DATENAME Example 4
Below queries find current quarter. Result of all the 3 queries is same:

SELECT DATENAME(quarter, getdate()) AS 'This is quarter'
SELECT DATENAME(q, getdate()) AS 'This is quarter'
SELECT DATENAME(qq, getdate()) AS 'This is quarter'

Result:
This is quarter
3

DATENAME Example 5
Below queries find current year. Result of all the 3 queries is same:

SELECT DATENAME(year, getdate()) AS 'This is year'
SELECT DATENAME(yyyy, getdate()) AS 'This is year'
SELECT DATENAME(yy, getdate()) AS 'This is year'

Result:
This is year
2017

DATENAME Example 6
Below query finds current timezone.

Select DATENAME(tz,SYSDATETIMEOFFSET())

Result:
(No column name)
+05:30

2 comments:

  1. Nice Post on DATENAME Function Examples. Thanks for sharing. Know More About Oracle PL SQL Interview Questions.

    ReplyDelete
  2. I'm very much inspired when I've visited your blog. Your blog is really informative. Hope you will continue with the new article.Oracle Managed Cloud Services

    ReplyDelete