Solved

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

Posted on 2014-01-31
4
771 Views
Last Modified: 2014-02-20
How do I convert these integers into human readable format?
fields.JPG
fields.JPG
0
Comment
Question by:sandshakimi
  • 2
4 Comments
 
LVL 17

Expert Comment

by:nanharbison
ID: 39824406
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
 
LVL 13

Expert Comment

by:Arrow_1
ID: 39824799
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
 

Author Comment

by:sandshakimi
ID: 39835516
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
 
LVL 13

Accepted Solution

by:
Arrow_1 earned 500 total points
ID: 39837386
0

Featured Post

Highfive + Dolby Voice = No More Audio Complaints!

Poor audio quality is one of the top reasons people don’t use video conferencing. Get the crispest, clearest audio powered by Dolby Voice in every meeting. Highfive and Dolby Voice deliver the best video conferencing and audio experience for every meeting and every room.

Join & Write a Comment

Foreword In the years since this article was written, numerous hacking attacks have targeted password-protected web sites.  The storage of client passwords has become a subject of much discussion, some of it useful and some of it misguided.  Of cou…
Fore-Foreword Today (2016) Maxmind has a new approach to the distribution of its data sets.  This article may be obsolete.  Instead of using the examples here, have a look at the MaxMind API (https://www.maxmind.com/en/geolite2-developer-package). …
This demo shows you how to set up the containerized NetScaler CPX with NetScaler Management and Analytics System in a non-routable Mesos/Marathon environment for use with Micro-Services applications.
When you create an app prototype with Adobe XD, you can insert system screens -- sharing or Control Center, for example -- with just a few clicks. This video shows you how. You can take the full course on Experts Exchange at http://bit.ly/XDcourse.

758 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

17 Experts available now in Live!

Get 1:1 Help Now