duanjianfu1398 2016-06-23 15:34
浏览 182
已采纳

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

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.

  • 写回答

1条回答 默认 最新

  • dongzhi2332 2016-06-23 16:09
    关注

    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
    
    本回答被题主选为最佳回答 , 对您是否有帮助呢?
    评论

报告相同问题?

悬赏问题

  • ¥30 帮我写一段可以读取LD2450数据并计算距离的Arduino代码
  • ¥15 C#调用python代码(python带有库)
  • ¥15 矩阵加法的规则是两个矩阵中对应位置的数的绝对值进行加和
  • ¥15 活动选择题。最多可以参加几个项目?
  • ¥15 飞机曲面部件如机翼,壁板等具体的孔位模型
  • ¥15 vs2019中数据导出问题
  • ¥20 云服务Linux系统TCP-MSS值修改?
  • ¥20 关于#单片机#的问题:项目:使用模拟iic与ov2640通讯环境:F407问题:读取的ID号总是0xff,自己调了调发现在读从机数据时,SDA线上并未有信号变化(语言-c语言)
  • ¥20 怎么在stm32门禁成品上增加查询记录功能
  • ¥15 Source insight编写代码后使用CCS5.2版本import之后,代码跳到注释行里面