Re: date problems

you can mimic the old behaviour like so: select TS, 1*TS as OldStyle; (TS being your timestamp filed) TS | OldStyle 2007-09-03 15:03:02 | 20070903150302 rDubya wrote: > > 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 >> >> > > -- > PHP Database Mailing List (http://www.php.net/) > To unsubscribe, visit: http://www.php.net/unsub.php > > > -- View this message in context: http://www.nabble.com/date-problems-tf4393599.html#a12634947 Sent from the Php - Database mailing list archive at Nabble.com.