On Lun 11 Feb 2002 23:18, you wrote: > > Why don't you use the SQL types for dates and times and then MySQL > will give you the correct ordering of times when you do an "order by" > clause.
I got to modify code that has a timestamp put in a varchar field, and the guy does the order by on that field. The worst part is that he had to do some outside coding to build the CURRENT_TIMESTAMP or now() that is already in the SQL engine. The normal MySQL programmers I know do these kind of things normally. Just a pity. :-( Saludos... :-) -- Porqué usar una base de datos relacional cualquiera, si podés usar PostgreSQL? ----------------------------------------------------------------- Martín Marqués | [EMAIL PROTECTED] Programador, Administrador, DBA | Centro de Telematica Universidad Nacional del Litoral ----------------------------------------------------------------- _______________________________________________ Redhat-list mailing list [EMAIL PROTECTED] https://listman.redhat.com/mailman/listinfo/redhat-list