15 Temmuz 2011 Cuma

DATENAME Türkçe gün,ay 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)

 

SET LANGUAGE Turkish;

 

SELECT

      DATENAME(month, TimeStart) AS MonthName,

      DATEPART(month, TimeStart) AS DayNum

      FROM ExecutionLogs

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

 

Changed language setting to Türkçe.

MonthName                      DayNum

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

Haziran                        6

Þubat                          2

Mayýs                          5

Temmuz                         7

Mart                           3

Nisan                          4

 

(6 row(s) affected)

Hiç yorum yok:

Yorum Gönder