Select Time Snippets


09 October, 2011   

Example shows how to get the database date and time.

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.

Mysql Code example to find events made between two times not between two dates.

08 February, 2016   

A type of replacement function within the SELECT statement.

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.

05 July, 2012   

Converts a date or time from one timezone to another.

10 October, 2012   

Converts a date or time from one timezone to another.

21 April, 2012   

Retrieves a list of "on call" incidents for the most recent time period. Selects all Support Analysts.

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.

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...

26 February, 2011   

Here shown how to highlight syntax

MySQL code example showing how to SELECT within a SELECT (a subselect).

03 March, 2011   

Count Script Execution Time

28 October, 2013   

C code example how to measure time of execution

30 November, 2014   

Mysql code example for Regular Expression SELECT statement

09 May, 2011   

This is a general code to use when selecting an item from a MySQL database. This code isn't considered definitive and can be written in many varied ways. Note: This code requires you to connect to the MySQL database to work. Also, all field and table names need to be set up to match. This MYSQL Code using in PHP