Sample Header Ad - 728x90

How to generate current Oracle timestamp in perl?

1 vote
1 answer
1693 views
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 unix gettimeofday() 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.
Asked by peterh (2137 rep)
Apr 28, 2014, 02:10 PM
Last activity: Jun 4, 2021, 07:50 PM