Solved

What does < unix_timestamp()

Posted on 2010-11-10
2
481 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

Comprehensive Backup Solutions for Microsoft

Acronis protects the complete Microsoft technology stack: Windows Server, Windows PC, laptop and Surface data; Microsoft business applications; Microsoft Hyper-V; Azure VMs; Microsoft Windows Server 2016; Microsoft Exchange 2016 and SQL Server 2016.

Question has a verified solution.

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

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). …
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://…
This video shows how to quickly and easily add an email signature for all users on Exchange 2016. The resulting signature is applied on a server level by Exchange Online. The email signature template has been downloaded from: www.mail-signatures…
Although Jacob Bernoulli (1654-1705) has been credited as the creator of "Binomial Distribution Table", Gottfried Leibniz (1646-1716) did his dissertation on the subject in 1666; Leibniz you may recall is the co-inventor of "Calculus" and beat Isaac…

786 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