Hello Mudassar
the solution you give is also not working becuase while converting nvarchar to datetime2 it giving the same error conversion failed
i have entered a Hijri shamsi date (1396-02-31) as nvarchar(50)
in the mention date the 2nd month in hijri shamsi date has 31 days
when i try to convert it to datetime 2 back it gives the following error
Conversion failed when converting date and/or time from character string.
Thanks