You are here: Re: Storing time in MySQL « PHP SQL « IT news, forums, messages
Re: Storing time in MySQL

Posted by larry on 04/02/07 00:47

On Mar 28, 8:06 am, "Schmalz" <gps...@tsn.cc> wrote:
> Hi again all,
>
> Just here to pick some more brains.
>
> I have some code that gets a date from a MySQL database and does some weird
> and wonderful calucaltions with it.
>
> I wish to store the end result back into the MySQL database. When I try it,
> using a number of different methods, it doesn't work.
>
> Any ideas as to the best way to store a date in a MySQL database using php?
>
> Thanks again in advance.
>
> Regards,
>
> Schmalz

I convert my time fields to minutes from midnight (midnight being 0,
1159pm being 1439) Its not human readable but it is computer
calculable.

When I need to have user reporting or input I have a set of functions
set up to do the conversions/validation as needed.

 

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

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