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
all sugestions are welcome
MySQL TIMESTAMP
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.
Then you can use the PHP date() function to do anything you want with it.
 |