inc_sqlite_time.nss

Go to the documentation of this file.

 
string SQLite_GetFormattedSystemTime(string format);
 
int SQLite_GetTimeStamp();
 
struct SQLite_MillisecondTimeStamp
{
    int seconds; 
    int milliseconds; 
};
 
struct SQLite_MillisecondTimeStamp SQLite_GetMillisecondTimeStamp();
 
string SQLite_GetSystemDate();
 
string SQLite_GetSystemTime();
 
 
string SQLite_GetFormattedSystemTime(string format)
{
    sqlquery query = SqlPrepareQueryObject(GetModule(), "SELECT STRFTIME(@format, 'now', 'localtime')");
    SqlBindString(query, "@format", format);
    SqlStep(query); // sqlite returns NULL for invalid format in STRFTIME()
    return SqlGetString(query, 0);
}
 
int SQLite_GetTimeStamp()
{
    sqlquery query = SqlPrepareQueryObject(GetModule(), "SELECT STRFTIME('%s', 'now')");
    SqlStep(query);
    return SqlGetInt(query, 0);
}
 
struct SQLite_MillisecondTimeStamp SQLite_GetMillisecondTimeStamp()
{
    sqlquery query = SqlPrepareQueryObject(GetModule(), "SELECT STRFTIME('%s', 'now'), SUBSTR(STRFTIME('%f', 'now'), 4)");
    SqlStep(query);
    struct SQLite_MillisecondTimeStamp t;
    t.seconds = SqlGetInt(query, 0);
    t.milliseconds = SqlGetInt(query, 1);
    return t;
}
 
string SQLite_GetSystemDate()
{
    return SQLite_GetFormattedSystemTime("%m/%d/%Y");
}
 
string SQLite_GetSystemTime()
{
    return SQLite_GetFormattedSystemTime("%H:%M:%S");
}