Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
saile
Starting Member
1 Post |
 Posted - 2010-08-25 : 20:28:05
|
| Hello,I was working on an project that required I stored the dates and time in Ethiopian Calender. The Ethiopian Calender is different from the Gregorian calender in many ways, The first big difference is it has 13 month, 12 months have 30 Days Each and there is one month with 5 Days and 6 days on leap years.http://en.wikipedia.org/wiki/Ethiopian_calendarIs there any functionality in SQL Server 2008 that supports such a date time natively. I am Need to successfully store this date time and be able to query it in so many ways.Many thanks in advance for the help. |
|
|
khtan
In (Som, Ni, Yak)
17689 Posts |
Posted - 2010-08-25 : 21:39:25
|
i don't think so. The easiest way is to build your own calendar table
KH[spoiler]Time is always against us[/spoiler] |
 |
|
|
Michael Valentine Jones
Yak DBA Kernel (pronounced Colonel)
7020 Posts |
Posted - 2010-08-25 : 22:05:17
|
| SQL Server does not have support for any non-Gregorian calendar.A khtan said, you will need to build your own calendar table. You might use the table created by the following function as a starting point, and add columns as needed to map from the Gregorian dates to the days, weeks, months, years, etc. of the Ethiopian calendar.Date Table Function F_TABLE_DATE:http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=61519CODO ERGO SUM |
|
|
|
|
|
|
Date Time In Ethiopian Calender