Re: Using date() function
| From: | @ Edwin | Date: | Sun, 06 Oct 2002 13:34:47 +0000 |
| Subject: | Re: Using date() function | ||
| References: | 1 | Groups: | php.general php.windows |
| Request: | Send a blank email to php-general+get-118994@lists.php.net to get a copy of this message | ||
Hello,
Why not just do it in your sql query?
If you're using MySQL perhaps this page would be helpful:
http://www.mysql.com/doc/en/Date_and_time_functions.html
Just an idea...
- E
On Sunday, October 6, 2002 10:01 PM
Davy Obdam wrote:
Hi people
I have a guestbook, and i need to convert the date and time from the
database into a normal readable date.. Like Sunday, 6 october 2002
13:30:00. I thought i could use the date() function here. I have done
this:
$entry_date = date('l, d F Y H:i:s','$sql["date"]');
echo $entry_date;
But then i dont get the date i need. It says Thursday, 01 January 1970
01:00:00 (i wasnt even born then;-), so it wasnt me signing that
guestbook. Any sugestions what i am doing wrong. Thanks for your time.
Best regards,
Davy Obdam,
mailto:info@davyobdam.com