RE: [PHP] syntax for date math expressions
| From: | Maxim Maletsky | Date: | Wed, 03 Apr 2002 21:37:11 +0000 |
| Subject: | RE: [PHP] syntax for date math expressions | ||
| References: | 1 | Groups: | php.general |
| Request: | Send a blank email to php-general+get-91422@lists.php.net to get a copy of this message | ||
In two words - here's your bible, Erik:
http://www.mysql.org/documentation/mysql/bychapter/manual_Reference.html
#Date_and_time_functions
Sincerely,
Maxim Maletsky
Founder, Chief Developer
PHPBeginner.com (Where PHP Begins)
www.phpbeginner.com
maxim@phpbeginner.com
> -----Original Message-----
> From: Erik Price [mailto:pricee@hhbrown.com]
> Sent: Wednesday, April 03, 2002 11:27 PM
> To: Rasmus Lerdorf
> Cc: php-general@lists.php.net
> Subject: Re: [PHP] syntax for date math expressions
>
>
> On Wednesday, April 3, 2002, at 04:14 PM, Rasmus Lerdorf wrote:
>
> > But you can simply call MySQL's UNIX_TIMESTAMP() function on the
mysql
> > field when you select it if you want it into unix timestamp format.
>
> For SELECTs, this is fine, but what happens when I want to insert a
new
> date? I transform all of my dates into Unix timestamps so that I can
> pass them around in form fields etc, but MySQL's timestamp format is
> different. Is there some way to call something like
> UNIX_TO_MYSQL_TIMESTAMP() in MySQL (or PHP)?
>
>
> Erik
>
>
>
>
> ----
>
> Erik Price
> Web Developer Temp
> Media Lab, H.H. Brown
> pricee@hhbrown.com
>
>
> --
> PHP General Mailing List (http://www.php.net/)
> To unsubscribe, visit: http://www.php.net/unsub.php