#select format

[luxuraire]

Rechargeable Motion Sensor LED Night Light

POV: You finally stop stepping on Legos at 2am 😩 This motion light = silent hero. 💡 Link in bio! https://luxuraire.com/rechargeable-motion-sensor-led-night-light

[mkassas-world]

How to convert Gregorian dates to Hijri date in SQL Server 2008 - 2012

How to convert Gregorian dates to Hijri date in SQL Server 2008 – 2012

To show your data as Hijri date in SQL Server 2008 and 2012 you can use the following format :

SELECT convert(nvarchar(10),GetDate(),131)

Output

16/08/1435

if you need to show the month name you can replace 131 with 130

SELECT convert(nvarchar(15),GetDate(),130)

Output

16 شعبان 1435

Note : you should to use nvarchar to show Arabic month name in correct

In SQL Server 2012 you can also use new…

View On WordPress