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



  • ¥100 求购一套带接口实现实习自动签到打卡
  • ¥50 MacOS 使用虚拟机安装k8s
  • ¥500 亚马逊 COOKIE我如何才能实现 登录一个亚马逊账户 下发新 COOKIE ..我使用下发新COOKIE 导入ADS 指纹浏览器登录,我把账户密码 修改过后,原来下发新COOKIE 不会失效的方式
  • ¥20 玩游戏gpu和cpu利用率特别低,玩游戏卡顿
  • ¥25 oracle中的正则匹配
  • ¥15 关于#vscode#的问题:把软件卸载不会再出现蓝屏
  • ¥15 vimplus出现的错误
  • ¥15 usb无线网卡转typec口
  • ¥30 怎么使用AVL fire ESE软件自带的优化模式来优化设计Soot和NOx?
  • ¥15 Ubuntu20.04.4.LTS系统如何下载安装VirtualBox虚拟机?