SQL Server 2005

Convert Decimal to Money SQL

In this article, I will explain how to Convert Decimal Numbers to Money with cents / without cents in SQL. You might also like to read How to convert Gregorian date to Hijri date SQL Server 2012 Convert Decimal to Money SQL I have a decimal number like  71567536.100000, I need to convert it to money format with …

Convert Decimal to Money SQL Read More »

How to convert Gregorian date to Hijri date SQL Server 2012

In this post, I will explain How to convert Gregorian date to Hijri date SQL Server 2012 Convert Gregorian date to Hijri date in SQL Server SQL Server 2012 introduces a new Format function that used to achieve the same result. Output 16/08/1435 You can also use the below query Output 16/08/1435 3:42:19:760PM Show Hijri date …

How to convert Gregorian date to Hijri date SQL Server 2012 Read More »

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 »