diff options
author | David Sommerseth <dazo@users.sourceforge.net> | 2012-10-07 16:08:38 +0200 |
---|---|---|
committer | David Sommerseth <dazo@users.sourceforge.net> | 2012-10-08 02:17:51 +0200 |
commit | 79b7a8c5ad5d4de6fc69d71585625b8a74198c47 (patch) | |
tree | deff813df996c47f2bdeb824577309a54ae8c3c7 /database/sqlite/sqlite.h | |
parent | b036940698442e61d7623702a7835af4d4e8e76a (diff) | |
download | eurephia-79b7a8c5ad5d4de6fc69d71585625b8a74198c47.tar.gz eurephia-79b7a8c5ad5d4de6fc69d71585625b8a74198c47.tar.xz eurephia-79b7a8c5ad5d4de6fc69d71585625b8a74198c47.zip |
sqlite: Added SQL function to convert datetime timestamps from UTC/GMT to localtime
All CURRENT_TIMESTAMP calls are returned in UTC/GMT, and this value is stored in the
database. When using eurephiadm to look at these datetime fields the UTC/GMT value
is used, and needs to be taken in consideration when looking at the reports. This
patch is the first step to handle the local time zone better.
This patch also fixes the 'debug' program in sqlite.c, making use of the
eurephia_log_init() and eurephia_log_close() calls for log preparations.
Signed-off-by: David Sommerseth <dazo@users.sourceforge.net>
Diffstat (limited to 'database/sqlite/sqlite.h')
-rw-r--r-- | database/sqlite/sqlite.h | 2 |
1 files changed, 2 insertions, 0 deletions
diff --git a/database/sqlite/sqlite.h b/database/sqlite/sqlite.h index 5a7c5fd..b521687 100644 --- a/database/sqlite/sqlite.h +++ b/database/sqlite/sqlite.h @@ -136,6 +136,8 @@ typedef struct __sqlite_dbresult { typedef enum _SQLqueryType { SQL_SELECT, SQL_INSERT, SQL_UPDATE, SQL_DELETE } SQLqueryType; +int sqlite_init_functions(eurephiaCTX *ctx); + /** * Free up a dbresult structure. This is the public interface for the * internal function _sqlite_free_results() |