Full Version: mysql, date
Pixel2Life Forum > Help Section > PHP, ASP, MySQL, JavaScript and other Web/Database Programming Help
when you the table row type is DATE, and you use CURDATE() to insert the date, the format is YYYY-MM-DD, is there a way in PHP to rotate the format to MM-DD-YYYY but still inserting it the way it's sapose to in the DB just changing the format on the page it's being displayed from?
I figured it out.... For all of you who are wondering as well here is my code:
before: YYYY-MM-DD
after: MM-DD-YYYY
enjoy!
before: YYYY-MM-DD
CODE
<?php
$date = list($year, $month, $day)=split('[/.-]', $row['date']); // [/.-] searches for the symbol(s) / . or -
$date = "$month-$day-$year";
echo $date;
?>
$date = list($year, $month, $day)=split('[/.-]', $row['date']); // [/.-] searches for the symbol(s) / . or -
$date = "$month-$day-$year";
echo $date;
?>
after: MM-DD-YYYY
enjoy!
So you know, list() doesn't return anything, so the following line should not have "$date = "
CODE
$date = list($year, $month, $day)=split('[/.-]', $row['date']); // [/.-] searches for the symbol(s) / . or -
But it works still doesn't it??? 
Only because PHP is interpreted. If it were a compiled language, something would probably yell at you.
Either way, it is not a practice you should get into.
Either way, it is not a practice you should get into.
witchcraft isn't a practice i should get into either
Ok, congradulations on solving the problem then.
battles are hard to win with hard-headed men thanks BTW lol
thanks BTW lol
you can use onlt timestamp
i think that's more easy
i think that's more easy
Correct, but I want to get acquainted with all mysql fields, rows, querys, etc etc...
This is a "lo-fi" version of our main content. To view the full version with more information, formatting and images, please click here.