date format question
Posted 23 October 2003 - 06:30 PM
to something like 10/22/2003 10:05 ??
can i modify the existing mysql format?
Posted 24 October 2003 - 12:52 AM
MySQL retrieves and displays DATETIME values in \'YYYY-MM-DD HH:MM:SS\' format.
I had the same issue and wanted to store the date in mysql in a custom format. I defined the column to be a TEXT instead of DATETIME and populated it with PHP
$datetime = date(\"d/m/Y h:i\");
Hope it helps.
Posted 25 October 2003 - 07:26 AM
Leave it as it is in the database and format it on output.
Donations gratefully received
|baaGrid| easy data tables - and more
|baaChart| easy line, column and pie charts
Posted 02 May 2008 - 04:34 PM
Posted 02 May 2008 - 06:13 PM
Debugging step #1: To get past the garbage-out equals garbage-in stage in your code, you must check that the inputs to your code are what you expect.
Programming is just problem solving, but it is done in another language. You must learn enough of the programming language you are using to be able to read and write code.
0 user(s) are reading this topic
0 members, 0 guests, 0 anonymous users