Format date with AM PM and without second in SQL Server 2012

 In this post, I will explain How to format date with AM PM and without second in SQL Server Format date with AM PM and without second in SQL Server Get current Hijri date in SQL Open a new query in SSMS > Drop the following query to show the data in Hijri format. SELECT CONVERT(VARCHAR(30),GETDATE(),131) AS …

Format date with AM PM and without second in SQL Server 2012 Read More »