I'd have to agree with Tom, it would be better to do the formatting using the DB since
MySQL stores its timestamp differently than the UNIX timestamp.
however, if you really want to do it in PHP you can use MySQL's function
UNIX_TIMESTAMP() to convert the db timestamp to a unix timestamp, then use PHP's
date() function to display the date.
so the code would look something like:
$sql = "SELECT UNIX_TIMESTAMP(lugar_lastinsert) from <table name> where <condition>";
.. db query code here
$row = mysql_fetch_array($result);
echo date("r", $row[0]);
> what database are you using?
I was wondering this as well, until i checked the subject
> It may be better to let the db do the formatting for you.
>
> --
> regards,
> Tom
*************************************************************************************
This e-mail, including any attachments to it, may contain confidential and/or personal
information.
If you have received this e-mail in error, you must not copy, distribute, or disclose
it, use or take any action
based on the information contained within it.
Please notify the sender immediately by return e-mail of the error and then delete the
original e-mail.
The information contained within this e-mail may be solely the opinion of the sender
and may not necessarily
reflect the position, beliefs or opinions of Salmat on any issue.
This email has been swept for the presence of computer viruses known to Salmat's
anti-virus systems.
For more information, visit our website at www.salmat.com.au.
*************************************************************************************
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
