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
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.