RE: [PHP-WIN] RE: [PHP] Re: Using date() function

Hi John, How do u use UNIX_TIMESTAMP or DATE_FORMAT in your query. My query now looks like this: "SELECT * FROM guestbook2002 ORDER BY entryID DESC LIMIT $entry, $show"; Can u help me;-) Thanks for your time Best regards, Davy Obdam, mailto:info@davyobdam.com -----Original Message----- From: John W. Holmes [mailto:holmes072000@charter.net] Sent: Sunday, October 06, 2002 3:31 PM To: 'Davy Obdam'; nicos@php.net; php-general@lists.php.net; php-windows@lists.php.net Subject: [PHP-WIN] RE: [PHP] Re: Using date() function > Using $entry_date = date('l, d F Y H:i:s',$sql['date']); now gives me > back Tuesday, 19 January 2038 04:14:07 with ever entry. $sql['date'] is > a TIMESTAMP and looks like this 20021006141256 in the datebase. It > should give me Sunday, 06 October 2002 14:12:56..? Wierd eh? Do u know a > solution? No, not weird. MySQL uses a timestamp in the YYYYMMDDHHMMSS format. Date() is expecting a UNIX timestamp, which is the number of seconds since Jan 1, 1970. So... you can either use DATE_FORMAT() in your query, with is the MySQL equivalent of date(). Look up the format in the manual. Or, you can use UNIX_TIMESTAMP() in your query to select out the unix timestamp instead of the mysql timestamp, and then use that value within date() in your PHP script. ---John Holmes... -- PHP Windows Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php