Time Interval Snippets


Demonstrates to select all the Birthdays that will occur as of today, 15 days

Select all the Birthdays that will occur as of today, 15 days

30 August, 2016   

Use INTERVAL to add or subtract days.

21 January, 2011   

Sometimes the time set on your server isn't accurate to what your local time is. If you can't change it, you can adjust it yourself. If your server thought it was 12 midnight, but it was really 7 pm, this will roll the $today variable back five hours to be correct.

19 October, 2013   

Mysql code shows how to calculate last 7 days

C source code example for using struct tm, time_t, and time to create a simple clock

This will return the number of seconds between now and when the time field was inserted.

22 June, 2014   

To test in other timezones, replace '-5' with your local standard time GMT offset.

By default, Delphi gets its date/time, currency and numeric format from Control Panel's International settings. We can set the constants defined in Delphi, like DecimalSeparator, ShortDateFormat and others like in the code below. To a complete list of these variables, look at Currency and date/time formatting variables in Delphi Help.

14 June, 2015   

This function helps you checking a UNIX timestamp with human readable time formats like 1m, 2d or 4y.

29 July, 2013   

Update random dates in MYSQL table

30 March, 2011   

Need to people out if they have been inactive for too long? Do it with this piece of code. This takes 3 functions to complete the inactive session task. 1. We need to check if the person is actually logged in using our isLogged function 2. We need the function to check the time the page loaded, and when the last page was loaded 3. We need a...

23 January, 2013   

Adjusted for daylight saving or standard time as appropriate.

04 May, 2011   

Need to people out if they have been inactive for too long? Do it with this piece of code. Introduction ----------------------- This takes 3 functions to complete the inactive session task. 1. We need to check if the person is actually logged in using our isLogged function 2. We need the function to check the time the page loaded, and when...

22 December, 2012   

How to update random dates in MYSQL table

04 January, 2014   

Example shows how to set Interval and set Timeout in jQuery

09 October, 2011   

Example shows how to get the database date and time.

31 December, 2011   

How to create a procedure for date calculation

03 March, 2011   

Count Script Execution Time

28 October, 2013   

C code example how to measure time of execution