在SQL Server中将datetime列的默认值设置为24h格式

Question

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.

Answer 1

Thank you so much everyone ! So to sum up I learned from you that "Datetime" is a binary value so it has no format.

So if it displays good in the SQL Server and not in my PHP website it is because php interpret the binary value differently.

To finally make it displays the way I want in PHP I format it in PHP using (note : $row["Date"] is the cell where I get the "Date" binary value from the SQL Server) :

$datee = new DateTime($row["Date"]);
$dateee = $datee->format('Y/m/d H:i:s'); 

And the output is now :

2016/06/22 10:46:00