|
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
Navigation:
[Reply to this message]
|