FRIHOST FORUMS SEARCH FAQ TOS BLOGS COMPETITIONS
You are invited to Log in or Register a free Frihost Account!


MySQL TIMESTAMP





golles
is it posible to change the output of the MySQL timestamp (or even beter the input) now it becomes: 2006-06-05 12:06:38 but I would prefer to make it: 12:06:38 05-06-2006

all sugestions are welcome Wink
Stubru Freak
You can make it output as a timestamp with UNIX_TIMESTAMP(`datefield`) (or something similar).
Then you can use the PHP date() function to do anything you want with it.
Related topics
mysql connection question
php admin and mysql admin console
Mysql And PHP HELP PLZ
MySQL statement error (got me going)
MySQL DB Backup script - minor problem
Help with mysql query
mySQL - Day, date, month, year, time Output/Input
What is the best way to save a date/timestamp in mysql
TIMESTAMP display format help
Spanish date functions in php and mysql
Okay so....
PHP/MySql database (Ver. 5)
MySQL dates
MySQL Error: Timestamp
Reply to topic    Frihost Forum Index -> Scripting -> Php and MySQL

FRIHOST HOME | FAQ | TOS | ABOUT US | CONTACT US | SITE MAP
© 2005-2011 Frihost, forums powered by phpBB.