What is the Created, Access and Login fields in Drupal User Table ?

sandshakimi
sandshakimi used Ask the Experts™
on
How do I convert these integers into human readable format?
fields.JPG
fields.JPG
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
These are timestamps, right? If you have the token module enabled, you can see how to refer to date formats in Drupal:
https://drupal.org/node/390482#drupal7tokenslist-token-date
Aaron FeledyDrupal Developer and Consultant

Commented:
These are unix timestamps representing a date and time. You can convert these into human readable formats using Drupal's format_date() function.

The 'created' timestamp represents the date and time the account was created. The 'access' timestamp represents the last time the user accessed the site. The 'login' timestamp represents the last time the user successfully completed the login process.

Author

Commented:
But if I want to export the User table to an .cvs file (to open in Excel), what SQL do I write so it exports readable date/time format for these fields, and not the current Unix format ?
Drupal Developer and Consultant
Commented:

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial