RE: [PHP] [Q] Converting SQL Datetimes to timestamps
| From: | Ed Lazor | Date: | Tue, 03 Aug 2004 18:32:51 +0000 |
| Subject: | RE: [PHP] [Q] Converting SQL Datetimes to timestamps | ||
| References: | 1 | Groups: | php.general |
| Request: | Send a blank email to php-general+get-192581@lists.php.net to get a copy of this message | ||
Check out strtotime in the PHP manual. It gives a few examples of how to
use the function that I think will answer your first question. Next, check
out mktime, time, and date.
> -----Original Message-----
> From: news [mailto:news@sea.gmane.org] On Behalf Of Michael T. Peterson
> Sent: Tuesday, August 03, 2004 11:05 AM
> To: php-general@lists.php.net
> Subject: [PHP] [Q] Converting SQL Datetimes to timestamps
>
> Evidently the strtotime() function will not convert an SQL datetime to a
> timestamp. Am I missing something? Here's an example of what I mean:
>
> $sql_datetime = '1948-30-03 01:30:00';
> $ts = strtotime( $sql_datetime );
> print( $ts.'<br>');
>
> When this script is executed, strtotime() returns -1.
>
> If true, that strtotime() is unable to convert SQL datetimes into
> timestamps, how are others accomplishing this?
>
> Cheers,
>
> Michael
>
> --
> PHP General Mailing List (http://www.php.net/)
> To unsubscribe, visit: http://www.php.net/unsub.php