Hello everyone
any one help me how to store hijri shamsi date in sql server hijri shamsi date are used to in most countries like Afghanistan, Iran and many other countires if i take datetime 2 it works fine but in some months like February has 28 days but the month in hijri shamsi calendar has about 30 days
now the question is how to deal with this kinds of problems
one solution is come to my mind is to store the date in Gregorian date and then convert them into hijri shamsi date but i will create performance issues