Posted by Geoff Berrow on 06/26/05 01:14

I noticed that Message-ID:
<uAkve.56488$G8.5111@text.news.blueyonder.co.uk> from Matthew Bates
contained the following:

>I need to add one second to the end time to ensure it is formatted
>correctly (e.g. 09:29:59 to 9:30am) however I just cannot see how to do
>it *correctly* - with PHP or MySQL. I may well be overlooking something
>but I would be grateful if anybody could help and point me in the right
>direction.


If you are storing this as a date, get a UNIX timestamp, add the second,
and format using PHP.

$sql="SELECT *, UNIX_TIMESTAMP($datefield) AS unixdate FROM `table`
";
--
Geoff Berrow (put thecat out to email)
It's only Usenet, no one dies.
My opinions, not the committee's, mine.
Simple RFDs http://www.ckdog.co.uk/rfdmaker/

[Back to original message]