Difference between revisions of "SQLite"
From dbawiki
| (7 intermediate revisions by the same user not shown) | |||
| Line 1: | Line 1: | ||
| − | + | 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 | + | * [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=== | ||
| + | * [http://www.sqlite.org/lang_datefunc.html Date and Time functions - sqlite.org] | ||
| + | Also julianday('now') as an equivalent for Oracle's sysdate | ||
| + | <pre> | ||
| + | select host, sid, datetime(started,'unixepoch','utc'), type from dbahawk_rman_summary where julianday(started) > julianday('now')-4 order by 1,2; | ||
| + | </pre> | ||
| + | <pre> | ||
| + | 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 | ||
| + | </pre> | ||
Latest revision as of 23:23, 28 May 2018
sqlite3 - a very handy little database as it is file based and is included with almost every platform.
- 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[edit]
Also julianday('now') as an equivalent for Oracle's sysdate
select host, sid, datetime(started,'unixepoch','utc'), type from dbahawk_rman_summary where julianday(started) > julianday('now')-4 order by 1,2;
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
