On Thursday 14 November 2002 05:27, Edward Peloke wrote:
> I have a date field in my mysql db, when I output the data to the screen, I
> don't want to see the minutes, just the mmddyy.
DATE fields in MySQL don't have the time (h:m:s).
> I can format a date but
> can't seem to get it to work passing in the value from
> $myrow["datefield"]....any ideas? I don't want to have to worry about just
> pulling what I want in the select clause, I just want to format it when I
> diplay it.
If you're pulling the dates from the db and just using it purely for display
then you may as well use DATE_FORMAT() on them in your query:
..., DATE_FORMAT(...) AS datefield, ...
where datefield is the name of your column holding the date.
If you're doing calculations on your dates in your PHP code then you should
convert them using UNIX_TIMESTAMP() in your query.
Jason Wong -> Gremlins Associates -> www.gremlins.biz
Open Source Software Systems Integrators
* Web Design & Hosting * Internet & Intranet Applications Development *
Only through hard work and perseverance can one truly suffer.
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php