Re: Timestamp Problem !!!???
[Your question has nothing to do with MySQL Transactions. Please choose a more appropriate forum (newbie) next time - you will probably get a faster reply]
Dinh Van Thao wrote:
> This field contain time that members post threads (in forum). Because this
> field is an integer so I don't known to query total posts of every member in database by month?
Is it in the 1,137,596,705 range? Then it probably is an UNIX timestamp.
You can use the FROM_UNIXTIME() and UNIX_TIMESTAMP() functions to work with these.
--
felix
Please use
BBCode to format your messages in this forum.
Edited 1 time(s). Last edit at 01/18/2006 09:08AM by Felix Geerinckx.
Subject
Views
Written By
Posted
2225
January 17, 2006 12:06AM
Re: Timestamp Problem !!!???
1545
January 18, 2006 09:07AM
1538
January 18, 2006 09:58PM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.