This is some work around Shamsi/Gregorian/Persian date
Each line is a holiday date in format yyyymmdd
It includes following columns in order:
ID,DATE_KEY,FULL_DATE_KEY,YEAR,SEASON,MONTH,WEEK,DAY_OF_WEEK,DAY_OF_MONTH,DAY_OF_YEAR,HOLIDAY,SEASON_PERSIAN_NAME,SEASON_ENGLISH_NAME,MONTH_PERSIAN_NAME,MONTH_ENGLISH_NAME,DAY_PERSIAN_NAME,DAY_ENGLISH_NAME
ID
: an auto generated id started from1
DATE_KEY
: date integer value in formatyyyymmdd
for example13950101
FULL_DATE_KEY
: date string value in formatyyyy/mm/dd
for example1395/01/01
YEAR
: year in integer value for example1395
SEASON
: season in integer from1
to4
MONTH
: month in integer value for example12
WEEK
: week in integer value for example52
DAY_OF_WEEK
: day of week in integer value while1
isSaturday
and7
inFriday
DAY_OF_MONTH
: day of month in integer value while1
is first of month and31
,30
or29
is the end of monthDAY_OF_YEAR
: day of year in integer value while1
is first of year and365
or366
is the end of yearHOLIDAY
: is it holiday or not. forformal holidays
andFridays
the value istrue
and otherwise it'sfalse
SEASON_PERSIAN_NAME
: season persian name in string. for exampleبهار
SEASON_ENGLISH_NAME
: season persian name in string. for exampleSpring
MONTH_PERSIAN_NAME
: month persian name in string. for exampleفروردین
MONTH_ENGLISH_NAME
: month persian name in string. for exampleFarvardin
DAY_PERSIAN_NAME
: day persian name in string. for exampleشنبه
DAY_ENGLISH_NAME
: day persian name in string. for exampleSaturday
The folder taghvim-shamsi
is the java project which we used to generate the csv file. You can use it if you
need to generate a customized csv file.