Solved

What does < unix_timestamp()

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

Efficient way to get backups off site to Azure

This user guide provides instructions on how to deploy and configure both a StoneFly Scale Out NAS Enterprise Cloud Drive virtual machine and Veeam Cloud Connect in the Microsoft Azure Cloud.

Question has a verified solution.

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

All XML, All the Time; More Fun MySQL Tidbits – Dynamically Generate XML via Stored Procedure in MySQL Extensible Markup Language (XML) and database systems, a marriage we are seeing more and more of.  So the topics of parsing and manipulating XM…
I have been using r1soft Continuous Data Protection (http://www.r1soft.com/linux-cdp/) for many years now with the mySQL Addon and wanted to share a trick I have used several times. For those of us that don't have the luxury of using all transact…
Get a first impression of how PRTG looks and learn how it works.   This video is a short introduction to PRTG, as an initial overview or as a quick start for new PRTG users.
Here's a very brief overview of the methods PRTG Network Monitor (https://www.paessler.com/prtg) offers for monitoring bandwidth, to help you decide which methods you´d like to investigate in more detail.  The methods are covered in more detail in o…

919 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

21 Experts available now in Live!

Get 1:1 Help Now