Code Comments
Programming Forum and web based access to our favorite programming groups.Hello: I have a talbe where there are 4 fields which involve dates and times. I have a php file named output.php and here is how I am doing it: $date1=mysql_result($result,$i,"date1"); $date2=mysql_result($result,$i,"date2"); $time1=mysql_result($result,$i,"time1"); $time2=mysql_result($result,$i,"time2"); This displays the data captured from the html form that I have. date1 & date2 are date fields and time1 and time2 are time fields. How would I display them? For example, date1 is now displaying like 2004-12-03. I understand that because that is how a date field is formatted in MySQL. But how would I get it to display, something like: Friday, 12/03/04? Same with time...how would I format it to display say 9:00 AM instead of 09:00:00? Thanks. David
Post Follow-up to this messageOn Wed, 24 Nov 2004 21:29:54 -0800, "C. David Rossen" <cdrossen@cdrmarketing.com> wrote: >how would I format it to display say 9:00 AM instead of 09:00:00? <http://uk2.php.net/manual/en/function.date.php> -- Interesting Xmas gifts: <http://www.awin1.com/tclick.php?id=405&mid=182> . <http:/ /BizOrg.co.uk/shopping/> Locate your Mobile phone: <http://www.bizorg.co.uk/news.html>
Post Follow-up to this messagePowered by vBulletin
Copyright 2000-2006 Jelsoft Enterprises Limited.