Re: date problems

WOW!! Thanks for all the help guys!! And Instruct ICC.. you're solution for pulling the events did work.. but.. it turns out that the solution was actually much simpler than I thought: The old mysql database (once again, not sure what version) stored the date as YYYYMMDDHHMMSS. The new database stores the date as YYYY-MM-DD HH:MM:SS. All I had to do was adjust my code to pull only the values and none of the delimeters (ie. "-", " ", and ":"). DUH!!!!!!! But once again, thanks you guys for all the help!!!! rDubya On 9/7/07, Instruct ICC <instructicc@hotmail.com> wrote: > >From: "Instruct ICC" <instructicc@hotmail.com> > >And while not trusting your indexing, rewrite short_date as: > My short_date rewrite was also wrong. So it looks like you will have to > learn those offsets for this function if you do it on the PHP side. But you > could also do it on the MySQL side. > > _________________________________________________________________ > Get a FREE small business Web site and more from Microsoft(r) Office Live! > http://clk.atdmt.com/MRT/go/aub0930003811mrt/direct/01/ > > -- > PHP Database Mailing List (http://www.php.net/) > To unsubscribe, visit: http://www.php.net/unsub.php > >