Blog Stats
  • Posts - 104
  • Articles - 0
  • Comments - 161
  • Trackbacks - 383

 

<< MS ASP.NET Portal Starter Kit | Home | BPEL (Business Process Execution Language) >>

Get Weekday (name) from a date in SQL Server

 

Today one of a friend wanted to know how to find out if todays is Sunday/Friday/Monday etc or not (ofcourse thats from within SQL Server, or else his mom wud have told him that :) )..
so here is the query that I told him:

select DATENAME(dw , getDate())

you can pass "dw" or "weekday" as a first parameter to date name which specifies the part of date returned.

so a sample query will be

SELECT case when DATENAME(dw , getdate()) <> 'Sunday' then 'Its Not Sunday today' else 'Its Sunday today' end

Hammad Rajjoub,
User Group Leader - Dot Net Wizards (http://dotnetwizards.blogspot.com),
Chariman UG Relations Committee (http://inetapakistan.org),
Member Speakers Bureau (http://mea.ineta.org)
Technical Lead, Meezan Bank Limited (www.meezanbank.com)

Print posted @ Sunday, January 09, 2005 3:17 PM

Feedback

# re: Get Weekday (name) from a date in SQL Server

Gravatar Exactly what I was looking for! Thanks! 1/23/2007 8:01 PM | Jeff Brand

# re: Get Weekday (name) from a date in SQL Server

Gravatar I was just looking for that!! Great ,thx! 11/23/2007 11:46 AM | Denis

# re: Get Weekday (name) from a date in SQL Server

Gravatar Cool thx needed that!! 12/9/2007 9:30 AM | Goofy

# re: Get Weekday (name) from a date in SQL Server

Gravatar Thanks, Just what I needed :-D
Keep Up the Good Work. 1/28/2008 10:53 PM | Ruchira

# re: Get Weekday (name) from a date in SQL Server

Gravatar Thank you!
2/7/2008 8:18 AM | Naomi

# re: Get Weekday (name) from a date in SQL Server

Gravatar very well stated. thanks! 3/9/2008 9:05 AM | VON

# re: Get Weekday (name) from a date in SQL Server

Gravatar Spot on, thanks 11/12/2008 4:11 AM | David Harrington

# re: Get Weekday (name) from a date in SQL Server

Gravatar THANK YOU! YOU"RE PRO!!! 2/19/2009 2:23 AM | THANK YOU! YOU"RE PRO!!!

# re: Get Weekday (name) from a date in SQL Server

Gravatar Great stuff; Thanks 2/25/2009 4:27 AM | Alfie

# re: Get Weekday (name) from a date in SQL Server

Gravatar kollam..nannayirikkunnu machu 3/16/2009 12:42 AM | thanks

# re: Get Weekday (name) from a date in SQL Server

Gravatar Thanks for this query 3/18/2009 8:30 AM | Vikas

# get second saturdays and fourth saturdays of a month

Gravatar sql query to get second saturdays and fourth saturdays of a month 3/24/2009 12:20 AM | diya

# re: Get Weekday (name) from a date in SQL Server

Gravatar thnx ..thnk u very much buddy. 4/24/2009 4:32 AM | pavan

# Просто отлично

Gravatar Согласен естественно :) Для меня это точно очень актуально :)
5/24/2009 1:32 AM | CЛACTEHA

# Увлекательно

Gravatar Хм... Но, как говорится, а воз и ныне там :)
6/19/2009 12:05 PM | Адриан

# Занятно

Gravatar Читал про это уже на каком то другом сайте, но у вас гораздо прикольней написано ;)
8/20/2009 8:11 PM | Balashka

# Прикольно

Gravatar Читал об этом в Википедии. Вообще конечно жизненная тема.
8/25/2009 9:36 PM | БЛOHДИHKA

# Познавательно

Gravatar Читал про это в Википедии. Вообще конечно занятная тема.
9/25/2009 8:19 AM | XAKER

# re: Get Weekday (name) from a date in SQL Server

Gravatar Thanks, it's useful for me 10/6/2009 9:01 AM | Jitendra

# re: Get Weekday (name) from a date in SQL Server

Gravatar Thanks. its useful. 10/22/2009 6:51 AM | lakshmi
Post a comment





 

 

 

Copyright © INETA Pakistan