I use DBI. And I want to make some like
INSERT INTO ... VALUES (the_generated_timestamp, ...);
What is the command? How could it be created, the perl ``ocaltime
scalar value has a very complex, for human eyes optimized format (f.e.Mon Apr 28 15:58:51 2014
). My goal were some like as the unixgettimeofday()` does (giving back the seconds since 1970.1.1), converted by some format string, which I can let eat by the Oracle.
But any simpler solution were also okay, if it exists.
It need to be generated in perl.
INSERT ... (current_timestamp, ...) isn't okay.