search

mirsaeedi / SQLCLR-Jalali-Date-Utility

Includes several functions to make it easier for you to work with Persian dates in SQL Server (2005+)
Apache License 2.0
22 stars 9 forks source link

dddd is not working #3

Closed gmareater closed 5 years ago

gmareater commented 5 years ago

hi

thanx for your great work, it's a nice work

now get to bussiness: 'dddd' command does not work correctly, i mean it does not return day name select dbo.GregorianToJalali(getdate(),'yyyy MM dddd')

but other commands seems to work correctly

mirsaeedi commented 5 years ago

Hi @gmareater. Thanks for reporting the issue. It got fixed. Run the new deployment script to update the function.

gmareater commented 5 years ago

thanx for your fast response,
but your deployment is missing assembly parts ( you need to redeploy) thanx in advance

CREATE ASSEMBLY [SqlCLR.JalaliDateUtility]
    AUTHORIZATION [dbo]

ALTER ASSEMBLY [SqlCLR.JalaliDateUtility]
    DROP FILE ALL