Oops, I used the wrong function in my post above. That should have been:
UPDATE w3t_Posts
SET B_Posted = UNIX_TIMESTAMP('2003-06-14 20:05:00')
WHERE B_Number = 123456
FROM_UNIXTIME() is the reverse function - it converts a timestamp into a readable date/time. It would be used for displaying an existing timestamp in the database, e.g.:
SELECT FROM_UNIXTIME(B_Posted)
FROM w3t_Posts
WHERE B_Number = 123456
With that change, it should work ok.
Reference:
MySQL Date and Time Functions.
-----
UBB.threads beta tester / threadsdev.com moderator
Software consulting services including UBB.threads problem resolution / installs / upgrades / customization.
