![]() |
SQL Query - format Date
I'm trying to run a MySQL query to list the members of a group and show the last activity date. The results gives me the date in a serial number like 1349148662
Here is my code. What do I need to add or change to format the query correctly ? Code:
SELECT `user`.`username` , `user`.`usergroupid` , `user`.`lastactivity` |
What it's returning is the timestamp. You can use PHP to convert to the date format of your choice with date(format, timestamp)
http://www.w3schools.com/php/func_date_date.asp I think there's a way to have MySQL do it but I forgot how it works |
Thanks. I've found theMySql format but I can't seem to get it to display. I get no errors so I assume it's not massively wrong.
Code:
SELECT `user`.`username`, `user`.`usergroupid` , DATE_FORMAT(`user`.`lastactivity`, '%d/%m/%Y') as `date_string` --------------- Added [DATE]1349158474[/DATE] at [TIME]1349158474[/TIME] --------------- OK, I got it working using the FROM_UNIXTIME function. Code:
SELECT username, usergroupid , FROM_UNIXTIME(lastactivity) AS ladate |
I guess that isn't a timestamp, but is generated by the PHP time() function at the time of the update. What MySQL wants is a proper timestamp, which looks like this: 2008-11-11 12:45:34. I don't know how you would convert using MySQL
|
As above, using the FROM_UNIXTIME I was able to reformat the lastactivity time correctly.
Now to tackle getting a search from two separate tables working. |
All times are GMT. The time now is 10:05 AM. |
Powered by vBulletin® Version 3.8.12 by vBS
Copyright ©2000 - 2025, vBulletin Solutions Inc.
X vBulletin 3.8.12 by vBS Debug Information | |
---|---|
|
|
![]() |
|
Template Usage:
Phrase Groups Available:
|
Included Files:
Hooks Called:
|