timothy bates (11/8/2010)
Should I get an error or count 2 instead of 3? :hehe:
Allthough not explicitly documented, the SQL Server data type supports the Gregorian calendar. The SET LANGUAGE affects the default date format, but does not change the calendar. Though the Greeks do not have September 21, 1916 in their national calendar, Gregorian September 21, 1916 does exist even in Greece (and equates to September 8, 1916 in the Greece national calendar).
If SQL Server would observe the national Greece calendar, it should also support the Bahá'í, Buddhist, Chinese, Eastern Christian, Ethiopian, Hebrew, Hindu, Indian, Iranian, Islamic, and Thai Solar calendars (*hopes he didn't miss a calendar*)
And based on the article you linked to, SET LANGUAGE Dutch should result in a follow-up question to determine the exact province... :w00t:
Oleg Netchaev (11/8/2010)
should be count(*) or even better count(1)
Why would that be better?