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 »
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 »
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 »
