15 Nisan 2011 Cuma

T-SQL DATENAME Turkish–Türkçe gün isimleri

SELECT

      DATENAME(dw, TimeStart) AS DayOfWeek,

      DATEPART(dw, TimeStart) AS DayNum

      FROM ExecutionLogs

      GROUP BY DATENAME(dw, TimeStart), DATEPART(dw, TimeStart)

DayOfWeek                      DayNum

------------------------------ -----------

Wednesday                      4

Tuesday                        3

Sunday                         1

Friday                         6

Thursday                       5

Saturday                       7

Monday                         2

 

(7 row(s) affected)

 

SET LANGUAGE Turkish;

           

SELECT

      DATENAME(dw, TimeStart) AS DayOfWeek,

      DATEPART(dw, TimeStart) AS DayNum

      FROM ExecutionLogs

      GROUP BY DATENAME(dw, TimeStart), DATEPART(dw, TimeStart)

Changed language setting to Türkçe.

DayOfWeek                      DayNum

------------------------------ -----------

Perşembe                       4

Pazartesi                      1

Pazar                          7

Salı                           2

Cumartesi                      6

Cuma                           5

Çarşamba                       3

 

(7 row(s) affected)

 

 

 

 

Hiç yorum yok:

Yorum Gönder