Posted by Matthew Bates on 06/26/05 01:16

Geoff Berrow wrote:
> 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`
> ";

Thanks for your quick reply.

I'm storing them as times, as they relate to any weekday/weekend day
rather than a specific date.

Matt

[Back to original message]