Get Day only from a datetime variable : Datetime « Date Timezone « SQL Server / T-SQL






  1. SQL Server / T-SQL
  2. Date Timezone
  3. Datetime

Get Day only from a datetime variable

18>
19> CREATE FUNCTION DayOnly(@Date datetime)
20> RETURNS varchar(12)
21> WITH SCHEMABINDING
22> AS
23> BEGIN
24>    RETURN CONVERT(varchar(12), @Date, 101)
25> END
26> GO
1> select dbo.DayOnly(GetDATE())
2> GO

------------
10/22/2006

(1 rows affected)
1> drop function DayOnly
2> GO
1>
2>








Related examples in the same category

1.DATETIME column
2.Converted to a datetime