So mysql has a time(type) in which it has a 24 hour clock stored that can ouput time in am/pm format with the mysql function date_format(). The only problem is that when the user doesnt select the time, the value that stores in the mysql database is 00:00:00 which turns out to be 12:00am when i echo it with php. So how would i frame it so it can tell a difference between a null value and 00:00:00 which is 12:00am? (Btw, i try inserting null into the time column, turns out to be 00:00:00, which is 12:00am).
2条回答 默认 最新
- douhunbei0166 2011-03-22 02:57关注
So how would i frame it so it can tell a difference between a null value and 00:00:00 which is 12:00am? (Btw, i try inserting null into the time column, turns out to be 00:00:00, which is 12:00am).
Make the column nullable. (Remove the NOT NULL constraint.)
本回答被题主选为最佳回答 , 对您是否有帮助呢?解决 无用评论 打赏 举报
悬赏问题
- ¥20 给自己本科IT专业毕业的妹m找个实习工作
- ¥15 用友U8:向一个无法连接的网络尝试了一个套接字操作,如何解决?
- ¥30 我的代码按理说完成了模型的搭建、训练、验证测试等工作(标签-网络|关键词-变化检测)
- ¥50 mac mini外接显示器 画质字体模糊
- ¥15 TLS1.2协议通信解密
- ¥40 图书信息管理系统程序编写
- ¥20 Qcustomplot缩小曲线形状问题
- ¥15 企业资源规划ERP沙盘模拟
- ¥15 树莓派控制机械臂传输命令报错,显示摄像头不存在
- ¥15 前端echarts坐标轴问题