[dbo].[dow]

(local) > mdb > Scalar-valued Functions > dbo.dow

Properties
Parameters
SQL Script
Uses

Property	Value
ANSI Nulls On
Quoted Identifier On

Parameters

Name	Data Type	Max Length (Bytes)
@fDate	datetime	8

SQL Script

/****** Object:  User Defined Function dbo.dow    Script Date: 12/1/2005 11:50:33 PM ******/

CREATE FUNCTION [dbo].[dow](@fDate datetime)
RETURNS varchar(3) AS
BEGIN
     RETURN convert(varchar(3), datename(dw, @fDate))
END
GO

Uses