Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 976
  • Last Modified:

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

How do I convert these integers into human readable format?
fields.JPG
fields.JPG
0
sandshakimi
Asked:
sandshakimi
  • 2
1 Solution
 
nanharbisonCommented:
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
0
 
Aaron FeledyDrupal Developer and ConsultantCommented:
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.
0
 
sandshakimiAuthor 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 ?
0
 
Aaron FeledyDrupal Developer and ConsultantCommented:
0

Featured Post

Become an Android App Developer

Ready to kick start your career in 2018? Learn how to build an Android app in January’s Course of the Month and open the door to new opportunities.

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now