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

Posted by Dmitry S. Dmitriev on 03/28/07 19:40

Just store it in unsigned int column as a php time() (unixtime) value....
You can get it from db using from_unixtime() function, or as is... You can
store it as is, or using unix_timestamp() function... Everything you
want.....

"Schmalz" <gpshea@tsn.cc> wrote in message
news:460a8491$0$4611$61c65585@un-2park-reader-01.sydney.pipenetworks.com.au...
> 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
>
>

 

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

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