Differences

This shows you the differences between two versions of the page.

--- sqlite [2018/12/08 12:49] – created 0.0.0.0
+++ sqlite [2019/01/30 11:32] (current) – external edit 127.0.0.1
@@ Line 1: / Line 1: @@
-====== SQLite ======
 sqlite3 - a very handy little database as it is file based and is included with almost every platform.
-  * [[http://perlmaven.com/simple-database-access-using-perl-dbi-and-sql|simple-database-access-using-perl-dbi-and-sql - perlmaven.com]]
+  *  [[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.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.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]]
+  *  [[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=====
+==== Convert Unix epoch time to local date and time format ====
-  * [[http://www.sqlite.org/lang_datefunc.html|Date and Time functions - sqlite.org]]
+  *  [[http://www.sqlite.org/lang_datefunc.html|Date and Time functions - sqlite.org]]
 Also julianday('now') as an equivalent for Oracle's sysdate
-<code>0@@</code>
+<code>
-<code>1@@</code>
+select host, sid, datetime(started,'unixepoch','utc'), type from dbahawk_rman_summary where julianday(started) > julianday('now')-4 order by 1,2;
+</code>
+<code>
+hn5407|crelsasa|2018-05-26 03:02:01|INCR(L1)
+hn5407|crelsasa|2018-05-27 03:01:40|INCR(L1)
+hn5407|crelsasa|2018-05-28 03:00:52|INCR(L0)
+hn5407|loana|2018-03-30 21:00:32|DB FULL
+hn5407|loana|2018-04-06 21:00:31|DB FULL
+hn5407|loana|2018-04-13 21:00:35|DB FULL
+</code>