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 »
In this post, we’re gonna solve the specified cast is not valid. (sqlmanagerui) error that occurs when you trying to restore a database from SQL Server 2012 to an earlier version. You might also like to read Database was backed up on a server running version 13 The specified cast is not valid. (sqlmanagerui) In
The specified cast is not valid. (sqlmanagerui) Read More »
