[wd_asp elements=’search’ ratio=’100%’ id=1]

Get Time from Database

26th February 2017

MySql

mysql codehaven category

Just run this as your SQL
SELECT NOW();

It returns ‘2017-02-25 23:50:26’

And this will return the timezone, so if your setting cron jobs, then check this as it will run at a different time.


select timediff(now(),convert_tz(now(),@@session.time_zone,'+00:00'));

Shows -05:00:00