Converting Persian date which are stored in Integer format to Gregorian date

[#1]

Hi

I have a sql database with Persian dates which are stored as Integer format e.g. 13950629. I would like to convert this to Gregorian date so that I can perform various operation such as finding the difference between 2 dates in days and months. I have already seen the following thread which converts the Gregorian dates to Iranian dates. My question is that how do I convert a integer into the correct format so I can join to the "persian_date.tsv.zip"?

How can sort special format date in search object's results?

Any suggestion are greatly appreciated.

Kind regards,

Farshid

[sunny_talwar]

Look at this thread:

Non-Gregorian calendars

[#3]

That was very useful. Thank you.

[sunny_talwar]

No problem