Drupal在SQL中创建了时间戳？

Question

So when user are created in drupal website it creates a table row in SQL database, everybody knows that, but there is column created witch stands for create date. It contains int type, something like this 1341319209. I checked, it isn't the milliseconds from 01.01.1970. The question is how can I convert it to normal date format using php or SQL Query? I tried to find how drupal does that, bet no success. Can someone please help. Write some code or give me a clue. :) Thanks.

Answer 1

You may try this:

MAKETIME( seconds / (60*60),
          seconds / 60,
          seconds % 60 )

or you may also try to use FROM_UNIXTIME()

SELECT
  from_unixtime(timestamp) 
FROM 
  your_table