sandshakimi
asked on
What is the Created, Access and Login fields in Drupal User Table ?
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.
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.
ASKER
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 ?
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
https://drupal.org/node/390482#drupal7tokenslist-token-date