i've used FROM_UNIXTIME with success. you can also supply a format. http://www.mysql.com/doc/en/Date_and_time_functions.html
hth
jeff
Mike Blezien
<[EMAIL PROTECTED] To: MySQL List <[EMAIL
PROTECTED]>
net.net> cc:
Subject: Timestamp
12/07/2003 12:23
PM
Please respond to
mickalo
Hello,
what is the best way to convert a TIMESTAMP value to a value
similar to a DATETIME value ??
thx's
--
Mike<mickalo>Blezien
=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=
Thunder Rain Internet Publishing
Providing Internet Solutions that work!
http://www.thunder-rain.com
Quality Web Hosting
http://www.justlightening.net
MSN: [EMAIL PROTECTED]
=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
