An useful php function to calculate a time difference between two dates given in sql format. If the newer date is not passed as second argument it would calculate the different between the old date and current time. So it would work as a “ago in words” kind of function as well. Continue reading
Vector Digital Clock plugin was created to show Digital Clock in more computerized and presentable way. With this plugin it is possible to show each digit or character of time in form of Digital Vector or character. This plugin works for different timezones and also takes care of the time differences arisen due to difference between your computer time and the server time. Continue reading
Here’s the path to DB file in CodeIgnitor admin end which contains query related stuff. Like building order, qhere and select blocks. One may want to do some debugging in this file. In this file i need to make no changes. Just for reference.
Now here’s how once could make a BETWEEN query for a date field. I wanted records for last 30 days. Continue reading