What is the best way to compare dates?
- How to string? "2012-04-29 23:00:01"
- how int? 1335726001
- another?
zenith zenith
2,063 2 nineteen 44
- 2The answer depends on thousands of things :) Where do the dates come from, how are they stored, what exactly is supposed to be done with them. Maybe they don’t need to be compared at all, because it makes sense to use INTERVAL in the database. Or maybe we need to convert them to / from RFC 3339 ... - user6550
|
2 answers
I would store them and compare as int. So, less memory is allocated, and comparison is faster, and, unlike lines, they can easily be converted to any desired format. However, @klopp said very correctly - it strongly depends on what you will do with them.
fori1ton fori1ton
22.2k 3 38 63
|
I think the time () function is simply not replaceable in this situation, firstly it creates int date value, secondly, you can always translate it into a normal (human) view, as well as calculate the difference between dates, even in negative values. Google - time PHP
Sergey Kashurin Sergey Kashurin
204 one eleven
|