I am using this Where Condition in One Of my query with MySql Database.My Problem is that i have one displaytime column in my table but that table column shows the data in UTC Time.and i want to co...

Can MySQL convert a stored UTC time to local time-zoned time directly in a normal select statement? Let's say you have some data with a timestamp (UTC). CREATE TABLE `SomeDateTable` ( `id` int(11)...

I know this sounds stupid, but when I use SELECT CONVERT_TZ('2004-01-01 12:00:00','UTC','Asia/Jakarta') AS time it outputs NULL. I'm using MySQL Workbench in Ubuntu 12.04 64 bit, and it works in...

I am trying to convert UTC time into the users local time, it works fine until I try to convert the time to +14:00 timezone, the result is always null, anyone has idea? Here is my code: select CON...

This sounds simple enough but I haven't been able to figure out how to use a simple SELECT statement to return the current time in GMT. I have been trying to use CONVERT_TZ() to convert NOW() to G...

My table 'my_logs' have about 20,000,000 records, and I want to find out how many logs I have in each date within a few days. I want to have a result like +------------+---------+ | date | count...

I have a query in mysql which compares 2 dates like this convert_tz(updatedDate,'+05:30','-05:00') < ? the convert function returns the value of column createddate in US Time. when I run this...

What is a practical way to store datetimes so that I can let users view/query data as of their own local time while keeping information about the original datetime. Basically, users want to be abl...

I have two tables with time stamps TABLE1 with TIME_STAMP in local time TABLE2 with TIME_STAMP in UTC I need to do something like select count(*) from TABLE1 where TIME_STAMP > TABLE2.TIME...

I am trying to set up a database that stores daily alert times as specified by users. For example, the user wants to receive an alert if some criterion is met each day between 7:00 AM and 7:30 AM. ...

I am new to solr and this is my first attempt at indexing solr data, I am getting the following exception while indexing, org.apache.solr.common.SolrException: Invalid Date String:'2011-01-07' ...

Hi I'm so confused with this UTC and GMT I'm inserting in MySQL table as ex column "event_date" like "2010-07-01 23:50:00" (datetime) my client asking an option in front end as GMT +1 GMT +2 GMT ...