> 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 General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
