Solved

What does < unix_timestamp()

Posted on 2010-11-10
2
482 Views
Last Modified: 2012-05-10
Hi

Can anyone explain to me what the statement < unix_timestamp() means?
0
Comment
Question by:Dan560
2 Comments
 
LVL 4

Assisted Solution

by:eleibowitz
eleibowitz earned 250 total points
ID: 34105698
It returns the number of seconds since January 1, 1970 at 0:00 (midnight at the end of Dec 31, 1969).
0
 
LVL 25

Accepted Solution

by:
jrb1 earned 250 total points
ID: 34105724
You would only want to use this to compare two values that are in a unix timestamp format.  Per the docs:

a Unix timestamp is the number seconds since '1970-01-01 00:00:00' UTC

If you don't pass a date/datetime to the function, it uses the current timestamp.  So,

< unix_timestamp()

mean, less than the current timestamp as represented by the Unix timestamp format, the number of seconds since 1/1/1970.
0

Featured Post

Active Directory Webinar

We all know we need to protect and secure our privileges, but where to start? Join Experts Exchange and ManageEngine on Tuesday, April 11, 2017 10:00 AM PDT to learn how to track and secure privileged users in Active Directory.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Introduction In this installment of my SQL tidbits, I will be looking at parsing Extensible Markup Language (XML) directly passed as string parameters to MySQL 5.1.5 or higher. These would be instances where LOAD_FILE (http://dev.mysql.com/doc/refm…
Foreword This is an old article.  Instead of using the MySQL extension that was used in the original code examples, please choose one of the currently supported database extensions instead.  More information is available here: MySQLi / PDO (http://…
The Email Laundry PDF encryption service allows companies to send confidential encrypted  emails to anybody. The PDF document can also contain attachments that are embedded in the encrypted PDF. The password is randomly generated by The Email Laundr…

821 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