SQLite - Revision history

Stuart at 23:23, 28 May 2018

2018-05-28T23:23:44Z

Stuart: /* Convert Unix epoch time to local date and time format */

2018-05-28T23:22:12Z

‎Convert Unix epoch time to local date and time format

Stuart at 23:21, 28 May 2018

2018-05-28T23:21:25Z

Stuart: /* Convert Unix epoch time to local date and time format */

2018-05-28T19:51:26Z

‎Convert Unix epoch time to local date and time format

Stuart: /* Convert Unix epoch time to local date and time format */

2018-05-28T11:19:01Z

‎Convert Unix epoch time to local date and time format

Stuart at 11:18, 28 May 2018

2018-05-28T11:18:12Z

Stuart at 13:32, 21 September 2014

2014-09-21T13:32:55Z

Stuart at 18:53, 2 September 2014

2014-09-02T18:53:30Z

Stuart at 18:53, 2 September 2014

2014-09-02T18:53:16Z

Stuart: Created page with "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-acc..."

2014-09-02T18:52:11Z

Created page with "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-acc..."

New page

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]

@@ Line 1: / Line 1: @@
-sqlite3 - 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 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://www.easysoft.com/developer/languages/perl/dbi-debugging.html#good-dbi-practise dbi good practise - easysoft.com]

@@ Line 9: / Line 9: @@
 Also julianday('now') as an equivalent for Oracle's sysdate
 <pre>
-select host, sid, datetime(started,'unixepoch','localtime'), type from dbahawk_rman_summary where julianday(started) > julianday('now')-4 order by 1,2;
+select host, sid, datetime(started,'unixepoch','utc'), type from dbahawk_rman_summary where julianday(started) > julianday('now')-4 order by 1,2;
 </pre>
 <pre>

@@ Line 6: / Line 6: @@
 ===Convert Unix epoch time to local date and time format===
 Also julianday('now') as an equivalent for Oracle's sysdate
 <pre>

@@ Line 6: / Line 6: @@
 ===Convert Unix epoch time to local date and time format===
-Also date('now') as an equivalent for Oracle's sysdate
+Also julianday('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;
+select host, sid, datetime(started,'unixepoch','localtime'), type from dbahawk_rman_summary where julianday(started) > julianday('now')-4 order by 1,2;
 </pre>
 <pre>

@@ Line 9: / Line 9: @@
 <pre>
 select host, sid, datetime(started,'unixepoch','localtime'), type from dbahawk_rman_summary where started > date('now')-4 order by 1,2;
 </pre>

← Older revision		Revision as of 13:32, 21 September 2014
Line 3:		Line 3:
	* [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]

@@ Line 2: / Line 2: @@
 * [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 onnect_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]

← Older revision		Revision as of 18:53, 2 September 2014
Line 2:		Line 2:
	* [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 onnect_to_a_sqlite_database_using_perl - microhowto.info]