Bastien Koert wrote:
> On Tue, Jul 28, 2009 at 10:43 AM, Miller,
> Terion<tmil...@springfi.gannett.com> wrote:
>>
>>
>> On 7/28/09 9:40 AM, "Bastien Koert" <phps...@gmail.com> wrote:
>>
>> On Tue, Jul 28, 2009 at 10:34 AM, Bob McConnell<r...@cbord.com> wrote:
>>> From: Miller, Terion
>>> On 7/28/09 8:35 AM, "Ashley Sheridan" <a...@ashleysheridan.co.uk> wrote:
>>>
>>>> $pastDays = strtotime("-30 days");
>>>> $date = date("d/m/y", $pastDays);
>>>>
>>>> Well I tried and got no results from my query and I know there
>>>> results with date ranges in the last 30 days, I basically need
>>>> to count backward from now() 30 days I thought strtotime() would
>>>> work well..but the fields in the db are varchar not date fields
>>>> they are all formatted the same though 00/00/00:
>>> If the dates are really stored as varchar, you are doing a lexical
>>> comparison on a field that is meaningless in that context. You will need
>>> to break the string down somewhere and do three separate comparisons.
>>>
>>> Bob McConnell
>>>
>>> --
>>> PHP General Mailing List (http://www.php.net/)
>>> To unsubscribe, visit: http://www.php.net/unsub.php
>>>
>>>
>> Teri,
>>
>> have you considered making the field a date/ datetime type? You could
>> add the column, then copy the data over with a sql statement casting
>> it to the correct date format you require and then drop the original
>> column
>>
>> --
>>
>> Bastien
>>
>> Cat, the other other white meat
>>
>> I don't think I can this data is being pulled from our county health site,
>> so it comes in how they put it on their page (scraping here) and I'm
>> grabbing it using regex. (and this is totally public info so it's legit-my
>> employer tells me)
>>
>>
>>
>
> Yep, if you are not in control of the data and are just screenscraping
> a site, then you don't have too many choices.
>
Why? If you're scraping it then you can cast it into whatever form you
want before you store it in the db. Scrape it, strtotime(), store it?
--
Thanks!
-Shawn
http://www.spidean.com
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
