[Croxeye.]

I need function that returns difference between two datetimes in seconds.

[Bugsy]

I recommend storing time in unix timestamp format, much easier to manage and do calculations with.

[Croxeye.]

Thank you, I didn't know about that before.

EDIT: can you just give me an example of the best way to get difference ?

[E1_531G]

new diff = get_systime() - timestamp

[Bugsy]

Yes, and you can easily convert a timestamp to any time value you want, down to the second.

[Croxeye.]

So I have to use TimeToUnix to convert DATETIME from database to unix format ?

[Natsheh]

How are you saving the date in the database as Unix timestamp value or as string date value.?


If you are saving it as a date you need to convert it to unix timestamp using bugsy include file for converting the date to unix its for easier purpose https://forums.alliedmods.net/showth...=91915?t=91915

[Croxeye.]

warning 213: tag mismatch

PHP Code:

    new iTimeDif, iTime, iRefDate, iYear, iMonth, iDay, iHour, iMinute, iSecond;
    new refDate = "2018-12-02 12:03:45"
    
    iTime = get_systime();
    iRefDate = TimeToUnix(refDate, iYear, iMonth, iDay, iHour, iMinute, iSecond); //error
    
    iTimeDif = iTime - iRefDate;
    
    UnixToTime(iTimeDif, iYear, iMonth, iDay, iHour, iMinute, iSecond);
    
    console_print(0, "iTimeDif: %s", iTimeDif); 


[Bugsy]

You cannot use the string version of time with this method.

PHP Code:

public CalcTimeDiff()
{
    new iTimeDif , iTime , iRefDate , iYear , iMonth , iDay , iHour , iMinute , iSecond;

    //Not sure why, but get_systime() now needs a -18000 offset, this may vary based on where your server is located.
    iTime = get_systime( -18000 );

    iRefDate = TimeToUnix( 2018 , 12 , 3 , 18 , 40 , 0 );
    
    iTimeDif = iTime - iRefDate;
    
    if ( iTimeDif >= 31536000 )
    {
        iYear = iTimeDif / 31536000;
        iTimeDif %= 31536000;
    }
    
    if ( iTimeDif >= 2678400 )
    {
        iMonth = iTimeDif / 2678400;
        iTimeDif %= 2678400;
    }
    
    if ( iTimeDif >= 86400 )
    {
        iDay = iTimeDif / 86400;
        iTimeDif %= 86400;
    }
    
    if ( iTimeDif >= 3600 )
    {
        iHour = iTimeDif / 3600;
        iTimeDif %= 3600;
    }
    
    if ( iTimeDif >= 60 )
    {
        iMinute = iTimeDif / 60;
        iTimeDif %= 60;    
    }
    
    if ( iTimeDif )
    {
        iSecond = iTimeDif;
    }    
    
    server_print( "%d years, %d months, %d days, %d hours, %d minutes, %d seconds" , iYear , iMonth , iDay , iHour , iMinute , iSecond );
} 


[shauli]

Originally Posted by Croxeye. warning 213: tag mismatch PHP Code:     new iTimeDif, iTime, iRefDate, iYear, iMonth, iDay, iHour, iMinute, iSecond;     new refDate = "2018-12-02 12:03:45"          iTime = get_systime();     iRefDate = TimeToUnix(refDate, iYear, iMonth, iDay, iHour, iMinute, iSecond); //error          iTimeDif = iTime - iRefDate;          UnixToTime(iTimeDif, iYear, iMonth, iDay, iHour, iMinute, iSecond);          console_print(0, "iTimeDif: %s", iTimeDif);

parse_time will be perfect here:

PHP Code:

    new iTime, iTimeDif;
    new refDate[ ] = "2018-12-02 12:03:45";
    
    iTime = parse_time(refDate, "%Y-%m-%d %H:%M:%S");
    iTimeDif = get_systime() - iTime;

    console_print(0, "iTimeDif: %d", iTimeDif); 


This code assumes that your refDate is in the past, if it's in the future just play with iTimeDif.
It will print the time difference in seconds, if you want to print full information (days/months/etc) then take a look at Bugsy's code right above me.