Need T-SQL to indicate if getdate() = Sunday

• Express12

  SSCoach

  Points: 18514

  More actions

  July 10, 2008 at 11:59 am

  #188061

  In search of T-SQL which will accomplish this: Given "any" date, tell me if this is a SUNDAY.

  Example:

  Declare @mydate datetime

  Select @mydate = (Select getdate())

  IF @mydate = 'Sunday' .....

  thx in advance

  BT

• Steve Jones - SSC Editor

  SSC Guru

  Points: 734489

  More actions

  July 10, 2008 at 12:06 pm

  #841019

  use Datepart and be sure you know what your datefirst setting is. You can set any day to be the first day of the week.

  I think you can also get the day name with datepart as well.

• Bijal Parekh

  Mr or Mrs. 500

  Points: 575

  More actions

  July 10, 2008 at 12:38 pm

  #841041

  when you use datepart and dw as the argument, it returns the weekday as integer value. where

  Sunday=1 and Saturday=7 as mentioned in BOL. I hope the below query helps.

  Declare @mydate datetime

  Select @mydate = (Select getdate())

  select datepart(dw,@mydate)

  IF (datepart(dw,@mydate) = 1)

  SELECT 'ITS A SUNDAY'

  else

  SELECT 'IT IS NOT A SUNDAY'

• Express12

  SSCoach

  Points: 18514

  More actions

  July 10, 2008 at 12:40 pm

  #841044

  hmmm -- isn't your repsonse analagous to something like this:

  Do you have a recipe for a chocolate cake?

  Yes, mix ingrediants and cook it. hahahaha (need specifics and preferrably an example please)

  I'm trying to leverage an experts T-SQL experience - where they may have this in their toolkit already.

  BT

• Brian-538429

  SSC Veteran

  Points: 244

  More actions

  July 10, 2008 at 12:40 pm

  #841046

  if datename(weekday, getdate()) = 'Sunday'

• Express12

  SSCoach

  Points: 18514

  More actions

  July 10, 2008 at 12:47 pm

  #841053

  thanks Grasshopper -- I modified your code to look like this:

  DECLARE@CheckDate DATETIME, @DayOfWeek SMALLINT

  SELECT @CheckDate = '2008-07-06 00:00:00.000'

  SELECT @DayOfWeek = (SELECT datepart(weekday, @CheckDate))

  SELECT @DayOfWeek As TheDay

  -- 1=Sunday

  BT