[8guawong]

PHP Code:

    char CurrentDate[20];
    FormatTime(CurrentDate, sizeof(CurrentDate), "%Y%m%d");
    PrintToChatAll(CurrentDate);
    char date1[64] = "20200601";
    char date2[64] = "20200531";
    PrintToChatAll("%d", StringToInt(date1) - StringToInt(date2)); 


with the above i didn't get 1

but if change date1 to 20200531 and date2 to 20200530 i get 1 which is correct

how do i get the correct day?

[zwolofmeister]

So basically you can do this;
int iNow = GetTime();
int iTomorrow = GetTime()+86400;

char szTime[20];
FormatTime(szTime, sizeof(szTime), "%m / %d / %y", iTomorrow); // This is tomorrows date
FormatTime(szTime, sizeof(szTime), "%m / %d / %y", iNow); // This is todays date

if this is not what you mean, you can check out this thread:
Liink

[Bacardi]

Like @zwolofmeister already said it.
It's better store and use unix epoch time (seconds).



You can use SQLite as calculator, tough

PHP Code:

public void OnPluginStart()
{
    RegConsoleCmd("sm_test", test);
}


public Action test(int client, int args)
{
/*
strftime(): A time string can be in any of the following formats:

    YYYY-MM-DD
    YYYY-MM-DD HH:MM
    YYYY-MM-DD HH:MM:SS
    YYYY-MM-DD HH:MM:SS.SSS
    YYYY-MM-DDTHH:MM
    YYYY-MM-DDTHH:MM:SS
    YYYY-MM-DDTHH:MM:SS.SSS
    HH:MM
    HH:MM:SS
    HH:MM:SS.SSS
    now
    DDDDDDDDDD 
*/

    char CurrentDate[50];
    FormatTime(CurrentDate, sizeof(CurrentDate), "%Y-%m-%d %H:%M:%S");
    //int seconds = GetSecondsBetweenDates("2020-05-01", "2020-06-10");
    //int seconds = GetSecondsBetweenDates("2020-05-01 01:22:10", "2020-06-10 20:01:11");
    
    int seconds = GetSecondsBetweenDates("now", "2020-06-13 16:55:11");

    PrintToServer("seconds %i", seconds);
    PrintToServer("days %i, hours %i, minutes %i, seconds %i", seconds / 86400, (seconds / 3600)%24, (seconds / 60)%60, seconds%60);

    return Plugin_Handled;
}


int GetSecondsBetweenDates(const char[] FirstDate, const char[] SecondDate)
{
    char error[512];
    Database db = SQLite_UseDatabase("sourcemod-local", error, sizeof(error));

    if(db == null)
    {
        LogError("%s", error);
        return -1;
    }

    char query[200];

    if(StrEqual(FirstDate, "now", true))
    {
        Format(query, sizeof(query), "SELECT strftime('%s','%s') - strftime('%s','%s','localtime');", "%s", SecondDate, "%s", FirstDate);
    }
    else
    {
        Format(query, sizeof(query), "SELECT strftime('%s','%s') - strftime('%s','%s');", "%s", SecondDate, "%s", FirstDate);
    }
    PrintToServer("%s", query)
    DBResultSet results = SQL_Query(db, query, sizeof(query));

    if(results == null)
    {
        LogError("DBResultSet results: invalid handle");
        delete db;
        return -1;
    }


    if(!results.HasResults || results.RowCount <= 0)
    {
        delete db;
        return -1;
    }

    int seconds = -1;
    if(results.FetchRow())
    {
        seconds = results.FetchInt(0);
    }

    delete results;
    delete db;


    return seconds;
} 


I made this quick. Haven't check more deeper in this.

*edit
With SQLite you can also do fancy date converts.
https://www.sqlite.org/lang_datefunc.html

[8guawong]

Originally Posted by zwolofmeister So basically you can do this; int iNow = GetTime(); int iTomorrow = GetTime()+86400; char szTime[20]; FormatTime(szTime, sizeof(szTime), "%m / %d / %y", iTomorrow); // This is tomorrows date FormatTime(szTime, sizeof(szTime), "%m / %d / %y", iNow); // This is todays date if this is not what you mean, you can check out this thread: Liink

yea i know how to get the date but i want to compare date
too bad you can't compare date the way i wanted when they are different months

Originally Posted by Bacardi Like @zwolofmeister already said it. It's better store and use unix epoch time (seconds). You can use SQLite as calculator, tough PHP Code: public void OnPluginStart() {     RegConsoleCmd("sm_test", test); } public Action test(int client, int args) { /* strftime(): A time string can be in any of the following formats:     YYYY-MM-DD     YYYY-MM-DD HH:MM     YYYY-MM-DD HH:MM:SS     YYYY-MM-DD HH:MM:SS.SSS     YYYY-MM-DDTHH:MM     YYYY-MM-DDTHH:MM:SS     YYYY-MM-DDTHH:MM:SS.SSS     HH:MM     HH:MM:SS     HH:MM:SS.SSS     now     DDDDDDDDDD  */     char CurrentDate[50];     FormatTime(CurrentDate, sizeof(CurrentDate), "%Y-%m-%d %H:%M:%S");     //int seconds = GetSecondsBetweenDates("2020-05-01", "2020-06-10");     //int seconds = GetSecondsBetweenDates("2020-05-01 01:22:10", "2020-06-10 20:01:11");          int seconds = GetSecondsBetweenDates("now", "2020-06-13 16:55:11");     PrintToServer("seconds %i", seconds);     PrintToServer("days %i, hours %i, minutes %i, seconds %i", seconds / 86400, (seconds / 3600)%24, (seconds / 60)%60, seconds%60);     return Plugin_Handled; } int GetSecondsBetweenDates(const char[] FirstDate, const char[] SecondDate) {     char error[512];     Database db = SQLite_UseDatabase("sourcemod-local", error, sizeof(error));     if(db == null)     {         LogError("%s", error);         return -1;     }     char query[200];     if(StrEqual(FirstDate, "now", true))     {         Format(query, sizeof(query), "SELECT strftime('%s','%s') - strftime('%s','%s','localtime');", "%s", SecondDate, "%s", FirstDate);     }     else     {         Format(query, sizeof(query), "SELECT strftime('%s','%s') - strftime('%s','%s');", "%s", SecondDate, "%s", FirstDate);     }     PrintToServer("%s", query)     DBResultSet results = SQL_Query(db, query, sizeof(query));     if(results == null)     {         LogError("DBResultSet results: invalid handle");         delete db;         return -1;     }     if(!results.HasResults || results.RowCount <= 0)     {         delete db;         return -1;     }     int seconds = -1;     if(results.FetchRow())     {         seconds = results.FetchInt(0);     }     delete results;     delete db;     return seconds; }  I made this quick. Haven't check more deeper in this. *edit With SQLite you can also do fancy date converts. https://www.sqlite.org/lang_datefunc.html

thx i went with the mysql route using DATEDIFF