Difference between revisions of "SQLite"

Revision as of 11:18, 28 May 2018

sqlite3 - a very handy little database as it is file based and included with almost everything.

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;

@@ Line 1: / Line 1: @@
-A very handy little database as it is file based and included with almost everything.
+sqlite3 - a very handy little database as it is file based and included with almost everything.
 * [http://perlmaven.com/simple-database-access-using-perl-dbi-and-sql simple-database-access-using-perl-dbi-and-sql - perlmaven.com]
 * [http://www.easysoft.com/developer/languages/perl/dbi-debugging.html#good-dbi-practise dbi good practise - easysoft.com]
 * [http://www.microhowto.info/howto/connect_to_a_sqlite_database_using_perl_dbi.html connect_to_a_sqlite_database_using_perl - microhowto.info]
 * [http://www.tutorialspoint.com/sqlite/sqlite_perl.htm 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
+<pre>
+select host, sid, datetime(started,'unixepoch','localtime'), type from dbahawk_rman_summary where started > date('now')-4 order by 1,2;
+</pre>