更改日期的格式 [英] to change the format of the date
问题描述
大家好,
好吧,我的情况是我在我的数据库中添加东西(类似的东西)。我使用的数据库是访问,我不得不将其更改为MySQL。当我开始知道访问和mysql的日期格式不一样时,我在我的phpmyadmin(wamp)中做了类似的事情 - >
Hi to all,
Ok the situation that i have is im adding things in my database(something similar).The database that i was using was access and i had to change it to MySQL.As i came to know the date format of access and mysql are not the same i did something like this in my phpmyadmin(wamp)-->
推荐答案
大家好,
好吧,我的情况是im在我的数据库中添加东西(类似的东西)。数据abase我正在使用的是访问,我不得不将其更改为MySQL。当我开始知道访问和mysql的日期格式不一样我在我的phpmyadmin(wamp)中做了类似的事情 - >
Hi to all,
Ok the situation that i have is im adding things in my database(something similar).The database that i was using was access and i had to change it to MySQL.As i came to know the date format of access and mysql are not the same i did something like this in my phpmyadmin(wamp)-->
发布您在该行使用的代码报告的例外情况。
Post the code you used at the line that was reported for the exception.
对不起,我忘记了错误信息......所以 - >
MYSQLException
SQLState:01004
消息:数据截断:日期值不正确:第24行''Req_Date''''24 / 10/2007''
错误:0 >
这就是我得到的。
sorry i forgot the error message..here goes-->
MYSQLException
SQLState:01004
Message:Data truncation: Incorrect date value: ''24/10/2007'' for column ''Req_Date'' at row 1
Error:0
this is all what im getting.
抱歉,我忘记了错误信息......所以 - >
MYSQLException
SQLState:01004
消息:数据截断:日期值不正确:''24 / 10/2007'列为''Req_Date ''在第1行
错误:0
这就是我得到的。
sorry i forgot the error message..here goes-->
MYSQLException
SQLState:01004
Message:Data truncation: Incorrect date value: ''24/10/2007'' for column ''Req_Date'' at row 1
Error:0
this is all what im getting.
我说发布了这个错误的Java代码?您确实说过您在JSP中遇到错误吗?也可以发布您的列类型。
I said post the Java code that is giving this error? You did say you are getting the error in the JSP right? Post also your column types.
这篇关于更改日期的格式的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!