Formating a timestamp from database
Posted: Thu Jan 15, 2004 3:24 pm
Using DreamweaverMX, PHP and MySQL/PHPadmin:
I'm trying to figure out how to use the "DATE_FORMAT('%Y,%m,%d')" to format my timestamp data coming from my database like "2004-01-01"....can't figure out the exact way to add the php code to my recordset data field so that it will work?
<?php echo $rs_requestview->Fields('request_date'); ?>
I've tried lots of things, still no luck.
Thanks!
Lynne
I'm trying to figure out how to use the "DATE_FORMAT('%Y,%m,%d')" to format my timestamp data coming from my database like "2004-01-01"....can't figure out the exact way to add the php code to my recordset data field so that it will work?
<?php echo $rs_requestview->Fields('request_date'); ?>
I've tried lots of things, still no luck.
Thanks!
Lynne