I used Bootstrap datepicker to get date from the user. I stored that value in database. But when i render this date in html, it showed unexpected value with the date !
I give the screen shot of the result.
Can anyone help me to solve this ?
Asked
Active
Viewed 54 times
0
-
1Perhaps an earlier question will help? http://stackoverflow.com/questions/1056728/where-can-i-find-documentation-on-formatting-a-date-in-javascript – Lance Leonard Jan 03 '15 at 16:51
1 Answers
1
How have you stored the date in the database?
Make sure you used DATETIME and not VARCHAR
Also how did you get the date from the database?
I would use:
$query = "SELECT DATE_FORMAT(ColumnName, '%Y-%m-%d %H:%i:%s') AS Date FROM Table";
$result = mysqli_query($cxn,$query) or die(mysqli_error());
$date = $result->fetch_object()->Date;
Mramaa
- 400
- 2
- 13
-
-
@Romeo You didn't specified a language. His answer is perfectly fine. – Ismael Miguel Jan 03 '15 at 17:25
-
$query = "SELECT DATE_FORMAT(ColumnName, '%Y-%m-%d %H:%i:%s') AS Date FROM Table"; Will this work in java ? – Jan 03 '15 at 17:58
-
-
-
After picking date by datepicker... i see it by console.log It shows the same with unexpected value. that means problem is in datepicker not in db. – Jan 05 '15 at 07:38
-
In that case I recommend trying this http://stackoverflow.com/questions/4772425/format-date-in-java – Mramaa Jan 05 '15 at 08:05