Sorting Date/Time In PHP

Chris Ramsey · 09-28-2009, 12:22 PM

Hey Warriors,

I'm looking for a way to sort dates and times with PHP.

Currently I'm using timestamps, but I'm really having a hard time wrapping my head around how I'm trying to do it.

What I'm looking to do is check for dates between (date a) and (date b) and add 1 to a variable every time one is found.

In theory this is easy, but I'm having a hard time with this today for some reason.

So, how would you recommend sorting yyyy-mm-dd hh:mm:ss? Of course, i'm open to using another format, if it's easier to sort through.

Robert Plank · 09-28-2009, 02:44 PM

Chris,

Store the dates using the numeric date representation... only worry about converting to yyyy-mm-dd when you display the dates to viewers.

Pro24 · 09-28-2009, 09:00 PM

If you strip yyyy-mm-dd mm:ss to this: YYYYmmddmmSS then you can use the built in php sorting, compare functions.
Just make sure you use the date field with leading 0!, otherwise it will not work. For example, in Day use the "d" as that represents a numerical value of the day with leading 0, from 0-31.

09-28-2009, 12:22 PM	#1
Chris Ramsey The Wandering Businessman War Room Member Join Date: Jan 2008 Location: The Globe Posts: 1,209 Thanks: 142 Thanked 755 Times in 196 Posts	Sorting Date/Time In PHP Hey Warriors, I'm looking for a way to sort dates and times with PHP. Currently I'm using timestamps, but I'm really having a hard time wrapping my head around how I'm trying to do it. What I'm looking to do is check for dates between (date a) and (date b) and add 1 to a variable every time one is found. In theory this is easy, but I'm having a hard time with this today for some reason. So, how would you recommend sorting yyyy-mm-dd hh:mm:ss? Of course, i'm open to using another format, if it's easier to sort through.
	Free - Instantly increase your email CTR by 200% or more... Free - How to earn $1k+ every month from local businesses...

09-28-2009, 02:44 PM	#2
Robert Plank PHP Author and Programmer War Room Member Join Date: Jul 2002 Location: Turlock, CA, USA. Posts: 4,024 Blog Entries: 82 Thanks: 28 Thanked 227 Times in 46 Posts Social Networking Contact Info	Re: Sorting Date/Time In PHP Chris, Store the dates using the numeric date representation... only worry about converting to yyyy-mm-dd when you display the dates to viewers.
	ONLY For Warriors: Free Exit Popup Plugin for WordPress (Exit Rescue)

09-28-2009, 09:00 PM	#3
Pro24 Warrior Member Join Date: Sep 2009 Posts: 6 Thanks: 0 Thanked 0 Times in 0 Posts	Re: Sorting Date/Time In PHP If you strip yyyy-mm-dd mm:ss to this: YYYYmmddmmSS then you can use the built in php sorting, compare functions. Just make sure you use the date field with leading 0!, otherwise it will not work. For example, in Day use the "d" as that represents a numerical value of the day with leading 0, from 0-31.