SQLite
From dbawiki
sqlite3 - a very handy little database as it is file based and included with almost everything.
- simple-database-access-using-perl-dbi-and-sql - perlmaven.com
- dbi good practise - easysoft.com
- connect_to_a_sqlite_database_using_perl - microhowto.info
- http://www.tutorialspoint.com/sqlite/sqlite_perl.htm
Convert Unix epoch time to local date and time format
Also date('now') as an equivalent for Oracle's sysdate
select host, sid, datetime(started,'unixepoch','localtime'), type from dbahawk_rman_summary where started > date('now')-4 order by 1,2;