Re: Datetime column index access

Jean Sagi wrote: > Not to argue... but > > Mark D. Stock wrote: > >> Octavio G'mez wrote: >> ... >> Sounds like bad database design, but if you can't change it... >> > > Why do you think this is a bad design? > Maybe a date column would be needed to consider it a good design? Well exactly, it sounds as though date & time are two separate attributes and should therefore be stored as such. Cheers, -- Mark. +----------------------------------------------------------+-----------+ | Mark D. Stock mailto:mdstock@MydasSolutions.com |//////// /| | Mydas Solutions Ltd http://MydasSolutions.com |///// / //| | +-----------------------------------+//// / ///| | |We value your comments, which have |/// / ////| | |been recorded and automatically |// / /////| | |emailed back to us for our records.|/ ////////| +----------------------+-----------------------------------+-----------+ sending to informix-list