SELECT
GETDATE() [Today Date],
CONVERT(VARCHAR(11),GETDATE(),131) [Hijri Date],
CONVERT(datetime, CONVERT(VARCHAR(11),GETDATE(),131), 131) [Gregorian Date]
Showing posts with label Hijri Date. Show all posts
Showing posts with label Hijri Date. Show all posts
Wednesday, December 30, 2015
Hijri Date to Gregorian Date or Vice Versa Sql Server
Hijri Date to Gregorian Date or Vice Versa Sql Server:
SELECT
GETDATE() [Today Date],
CONVERT(VARCHAR(11),GETDATE(),131) [Hijri Date],
CONVERT(datetime, CONVERT(VARCHAR(11),GETDATE(),131), 131) [Gregorian Date]
SELECT
GETDATE() [Today Date],
CONVERT(VARCHAR(11),GETDATE(),131) [Hijri Date],
CONVERT(datetime, CONVERT(VARCHAR(11),GETDATE(),131), 131) [Gregorian Date]
Subscribe to:
Comments (Atom)