Re: Re: days of the week, time calculations

php3@developersdesk.com wrote: > ** Reply to note from Egon Schmid <eschmid@php.net> Sat, 08 Jul 2000 16:26:13 +0200 > > > > Kenn Murrah wrote: > > > > > I need to convert MySQL's timestamp into a format > > > that I can use for calculating the number of seconds > > > between two date/times. I also need to be able to > > > determine what day of the week a given timestamp > > > is. > > > > > > I've looked everywhere that I can think of to look -- can > > > anyone point me in the right direction? > > > > http://zend.com/manual/ref.datetime.php and look for > > date() and > > mktime(). > > > > I would suggest you look in the MySQL manual for ways to format MySQL > date/time/timestamp fields: > > > http://www.mysql.com/documentation/mysql/commented/manual.php?sectio > n=Date_and_time_functions > > You may have to re-format the URL go make it fit on one line... I know that, but this is an PHP mailing list and not the mailing list for MySQL. BTW: I can recommend the book from Paul DuBois, MySQL, New Riders Publishing. Paul helps also to make the PHP and MySQL manual more readable. All books can be viewed at http://php.net/books.php. Since last week there is a German translation of Paul's book available. -Egon -- SIX Offene Systeme GmbH · Stuttgart - Berlin - New York Sielminger Straße 63 · D-70771 Leinfelden-Echterdingen Fon +49 711 9909164 · Fax +49 711 9909199 http://www.six.de