finding the Day of the week?

• mick burden

  SSCarpal Tunnel

  Points: 4432

  More actions

  November 15, 2005 at 2:52 am

  #167014

  can anyone help please, I need to find the day of the week as a word in a Stored Procedure, in VB I would use :-

   

  dayofweek = format(date,"dddd") -- this would return "Monday" or something like it

   

  can some one tell me what the equilivent is please

• mick burden

  SSCarpal Tunnel

  Points: 4432

  More actions

  November 15, 2005 at 3:45 am

  #603849

  I've just discovered how to do it, I've posted what I've found below

  set @sDayofWeek = datename(weekday,'10/11/2005') -- returns "Tuesday"

  set @sDayofWeek = datename(day,'10/11/2005') -- returns "10"

  set @sDayofWeek = datename(month,'10/11/2005') -- returns "November"

  set @sDayofWeek = datename(year,'10/11/2005') -- returns "2005"