The Time Zone issue has been solved. 

I have used this approach even in the erp and it works good. Also, how are you storing the date in the table? the format in the code is not accepted by mysql i suppose