Re: If date is greater than

From: Date: Sun, 20 Oct 2013 15:50:22 +0000
Subject: Re: If date is greater than
References: 1 2 3  Groups: php.general 
Request: Send a blank email to php-general+get-322339@lists.php.net to get a copy of this message
On Oct 20, 2013, at 4:01 AM, Ashley Sheridan <ash@ashleysheridan.co.uk> wrote: > Yes, I was going to ask, why are you storing your dates as strings? > MySQL has a perfectly good DATE type. It's also generally faster > comparing dates within a MySQL query than PHP code. > > Thanks, > Ash > http://www.ashleysheridan.co.uk Agreed. Plus, there are many date functions provided by MySQL that are easier (possibility faster) than what you can do in PHP. Check these out: http://dev.mysql.com/doc/refman/5.5/en/date-and-time-functions.html#function_date tedd _______________ tedd sperling tedd.sperling@gmail.com

« previous php.general (#322339) next »