You are here: Re: Times « PHP Programming Language « IT news, forums, messages
Re: Times

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]


Удаленная работа для программистов  •  Как заработать на Google AdSense  •  England, UK  •  статьи на английском  •  PHP MySQL CMS Apache Oscommerce  •  Online Business Knowledge Base  •  DVD MP3 AVI MP4 players codecs conversion help
Home  •  Search  •  Site Map  •  Set as Homepage  •  Add to Favourites

Copyright © 2005-2006 Powered by Custom PHP Programming

Сайт изготовлен в Студии Валентина Петручека
изготовление и поддержка веб-сайтов, разработка программного обеспечения, поисковая оптимизация