New Topic/Question
Reply
Hi all.
I am grabbing two time stamps from a mysql db and storing them in variables, the timestamps are stored in the format YY-MM-DD HH:MM:SS .
Could anyone tell me how I might go about comparing two timestamps that are in this format, I need to check if one is older than the other.
Thank you for your time.
3 Replies - 409 Views - Last Post: 16 March 2013 - 01:41 PM
Rate Topic:
MultiQuoteReplies To: Compare two timestamps
#3
matn89
- New D.I.C Head
Reputation: 0
- Posts: 7
- Joined: 12-February 13
Re: Compare two timestamps
Posted 16 March 2013 - 01:35 PM
andrewsw, on 16 March 2013 - 01:33 PM, said:
It depends: what are the field data-types? Are they stored as strings or DATETIME (I assume) or TIMESTAMP?
They are stored as the type TIMESTAMP .
Thanks
Was This Post Helpful?
0
#4
andrewsw
- Provides a RESTful service
-
Reputation: 1094
- Posts: 3,406
- Joined: 12-December 12
Re: Compare two timestamps
Posted 16 March 2013 - 01:41 PM
If they are DATETIME (or TIMESTAMP) fields then it is more efficient to only retrieve the dated-records that you need, in the SQL statement:
..but if you need them as dates in the PHP then you might use strtotime() to convert them, having retrieved the values from the database. discussed here
Of course, this being PHP, there are a dozen other ways to approach this.
WHERE date1 < date2
..but if you need them as dates in the PHP then you might use strtotime() to convert them, having retrieved the values from the database. discussed here
Of course, this being PHP
, there are a dozen other ways to approach this.
This post has been edited by andrewsw: 16 March 2013 - 01:38 PM
Was This Post Helpful?
1
Page 1 of 1
|
|
| 