Re: syntax for date math expressions
| From: | Rasmus Lerdorf | Date: | Wed, 03 Apr 2002 21:24:37 +0000 |
| Subject: | Re: syntax for date math expressions | ||
| References: | 1 | Groups: | php.general |
| Request: | Send a blank email to php-general+get-91416@lists.php.net to get a copy of this message | ||
date()
On Wed, 3 Apr 2002, Erik Price wrote:
>
> 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
>