Melissa W. Dickens wrote:
Thank you VERY much Jay, Chris and Gary!
I tried the php code to change it and that worked Great, as Chris suggested
I am about to see how it flies with changing the SQL DB directly as Gary
suggested.
I might even just ADD a new DB field for the new format...
The mktime function looks VERY interesting, but confusing to a newbie...
That will be next on my list of things to try.
Melissa
No need to create a new field just for another format. If you are using
mysql 5 you can create a view.
mysql> create view view_name as select DATE_FORMAT(time_column,
'%h:%i:%s %p') as time from your_table;
Query OK, 0 rows affected (0.00 sec)
mysql> select * from view_name;
+-------------+
| time |
+-------------+
| 12:45:41 PM |
+-------------+
1 row in set (0.00 sec)
This way you're not updating multiple columns with the same data
formated differently.
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
