Kim Jacobs - MWEB wrote:

I have a script which pulls a date(date default NULL) and a time (time default NULL) 
from a MySQL database, now I would like to display that date and time in a 'pretty' 

I've been able to show the date nicely with the help of this:

                $ntime=strtotime($row['date'] $row['time']);
                $ndate=date('D d F Y H:i',$ntime);

This shows the date in a 'nice' format (2004-05-10 20:40:00 is shown as Mon 10 May 
2004 00:00), however, it shows the time as 00:00 for all of the games no matter what 
the time is. How do I get it to show the date as 20:40 or 20h40 or 8:40 PM?

If I change the lines to this:
                $ntime=strtotime("$row[date] $row[time] GMT");
                $ndate=date('D d F Y H:i',$ntime);
the only difference is that it now shows Mon 10 May 2004 02:00 (probably because we 
are 2 hours ahead of GMT)

Any ideas please?


Well, a solution could easily be arranged to use both fields, but really, the best thing to do is to just use a DATETIME field in MySQL instead of using both DATE and TIME fields. That will save you a lot of headaches now and in the future.

    Bruno Ferreira
[This E-mail scanned for viruses by Declude Virus]

PHP Database Mailing List (
To unsubscribe, visit:

Reply via email to