Hi, I'm using a Oracle table in which date are stored in number of seconds since January 1st 1970.
I've been succesfully able to convert number of seconds to a correct format string (YYYY-MM-DD HH:MM:SS) using DateTime::Precise module, but I don't know how to do the reverse operation. Is there any way using Oracle SQL to SELECT for a date between two dates, when dates are given in a string (YYYY-MM-DD HH:MM:SS) and the date field in the table is a number of seconds ? Otherwise what Perl module can I use to do this operation ? Thanks Thomas Petazzoni [EMAIL PROTECTED] KOS : http://kos.enix.org Perso : http://kos.enix.org/~thomas/
