Re: PHP query on "date" field

The date field is varchar. And I believe it is for daylight savings. I am trying out a couple of things on a test date field so I will get back with you guys after I try your suggestions. And by the way I sincerely appriciate all the help you and Rick are giving me. Thanks again, jason "Jason Wong" <phplist@gremlins.com.hk> wrote in message news:php.db-13867@news.php.net... > On Wednesday 31 October 2001 04:34 am, Jason wrote: > > > This portion of the site was done by a previous employee and well > > you know the expression.. "If its not broke don't fix it." Well now > > that I cannot query the db by the date it is now broke and I am still > > figuring out how MySQL is taking entries to the db so I figured this > > bit of information would maybe sum up the problem in the date field. > > I have been reading up on the date function in the MySQL book I have > > but somethings it just doesn't cover. So please excuse my being > > vague. Thanks, > > Jason > > What data type is your date field -- CHAR? INT? DATE? > > > > > date("H") converts to a 24-hour clock. That is, 00 is 12 > > > mid-night, 01 is > > > > 1 > > > > > AM, 13 is 1 PM, 14 is 2 PM, 23 is 11 PM, etc. > > > > > > I do not understand the reasons for your computation that, say 00, > > > is 10 > > A stab in the dark -- could it be some time-zone adjustment? > > > > Ok well I have made the changes and tested it out but using the > > > search string 10/15/2001 still provided no results... > > The changes would only work if your date field is of data type DATE (or > DATETIME). > > > > here is the > > > script that parses the date for entry into the database... > > > $date = (date("m/d/Y")) ; #this date is used in the online > > > database > > > I am wondering if I should let the date be put into the db as > > > > 2001-15-10... > > Changing the format of your dates to standard DATE or DATETIME *would* > be a sensible thing to do :) > > > -- > Jason Wong > Gremlins Associates > www.gremlins.com.hk