Tag Date and time functions

Date manipulation with mysql..

Posted on February 10, 2014 by Suresh Kamrushi in PHP

There are various instance when we do date calculation on date / unix datetime fields.Following are some example as how to use inbuilt functions of mysql which will reduce doing calculation in PHP, I hope it will help someone:

How Mysql reduce overhead from PHP!!!!!

Posted on August 10, 2013 by Suresh Kamrushi in Mysql, PHP

I enjoy to play with Mysql queries. what i learn from my past experience is,if you are doing a maintainance project or you are handling a project which is developed by some other developer and he mess up with the database definitions, than you “WILL LEARN A LOT NEW THINGS”…………. How?

PHP: Calculating Business days from given dates or for particular period.

Posted on August 10, 2013 by Suresh Kamrushi in PHP

Whenever i get time i used to answers in PHP related questions in Stackoverflow. Today i come across common question being ask by number of developers, is to get the “Bussiness days” in a specific period. Developer write unneccessary of lines of codes, which we can get easily by using Datetime functions available with PHP.