Re^6: What do people want from DB abstraction modules?

[techcode]

Yes date/time fields are nightmare. I agree.

Latter mentioned Rose::DB has code that translates from Perl format to DB in use format and the other way around.

I'm planing to support that but still not sure how to implement it. Do it automatically on read/write (behind the scenes) by figuring out if field is date/time - or perhaps export a function (or call as $DB->dt_format($value_here);) for that so it's done manually?

In case of writing (UPDATE/INSERT) it's not a (performance) problem to do the conversion in Perl, but it would be stupid to loop through all the results just to format the date/time fields. So I guess it should be implemented in SQL itself?

---

[suaveant]

Yeah... being able to use something like date_format in mysql on the query side would probably be the way to go.... I assume most databases can handle it... of course, people should be able to define their date format of choice.