I want to set the default value of my "Date" column (using getdate() by exemple) to be stored in 24h and not in 12h format.
In my SQL Server database I set the default value to be : getdate(). In the database it displays like I want it in 24h format : 22/06/2016 10:46:00
But when I get this value in my php website I get the following value : Jun 22 2016 10:46:00:000AM
I know that there are ways to convert for what I want like : SELECT CONVERT(VARCHAR(24), GETDATE(), 113)
But I can't set this query to be the default value of my "Date" column.