Hi Nicos,
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
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?
: John W. Holmes [mailto:[EMAIL PROTECTED]]
Sent: Sunday, October 06, 2002 3:31 PM
To: 'Davy Obdam'; [EMAIL PROTECTED]; [EMAIL PROTECTED];
[EMAIL PROTECTED]
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
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
Did you read the Date and Time Functions chapter of the MySQL manual??
SELECT
4 matches
Mail list logo
