SQL Get the Weekday of a Date | SQL did you know

Описание: Get the Weekday of a Date or Datetime
Here the Function

-- =============================================
-- Author: I made a Chart
-- Create date: 2023-08-17
-- Description: Get the Weekday of a Date / Datetime
-- And leaf an Abo if you read this ;-)
-- =============================================
CREATE FUNCTION get_WeekDay
(
@date Datetime
)
RETURNS varchar(10)
AS
BEGIN
DECLARE @weekDay varchar(9) = NULL

set @weekday = case
when (datepart(WEEKDAY, @date) = 1)
then 'Sunday'
when (datepart(WEEKDAY, @date) = 2)
then 'Monday'
when (datepart(WEEKDAY, @date) = 3)
then 'Tuesday'
when (datepart(WEEKDAY, @date) = 4)
then 'Wednesday'
when (datepart(WEEKDAY, @date) = 5)
then 'Thursday'
when (datepart(WEEKDAY, @date) = 6)
then 'Friday'
when (datepart(WEEKDAY, @date) = 7)
then 'Saturday'
end
RETURN @weekday

END
GO
______________________________________________
Source:

______________________________________________
HashTags:
#SQLAdventure #DataDive #NerdKnowledge #TechMagic #DatabaseMagic #SQLExploration #GeekyTech #CodeCrush #DataWizard #QueryQuest #TableTales #ByteSizedSQL #TechTidbits #CodeMagic #CuriousCoder #DigitalDiscoveries #TechEnthusiast #BytesOfWisdom #GeekLife #DiveIntoData #TechExploration
______________________________________________
Software:
Microsoft SQL Server Manager Studio 2018
Google Translate
OBS Studio
CapCut (FreeVersion)