Google line chart displays wrong timeofday values

Question

0.00/5 (No votes)

See more:

Hello all,
I have a chart that has 2 columns with 'timeofday' and 'number' format. The chart gets displayed but the time value is wrong. If the time is 00:00 (HH:mm), it displays as 05:30 which adds +05:30 for all the time values. I have included timezone but that does not create any impact on the values. Please help how to handle this. I am stuck in this...

What I have tried:

C#

google.charts.load('current', {'packages':['line']});//type of chart is line chart
    google.charts.setOnLoadCallback(drawChart);

var dateFormatter = new google.visualization.DateFormat({formatType: 'long',timeZone: -0530 });
dateFormatter.format(data,0);

Posted 14-Mar-17 1:26am

User1454

Updated 14-Mar-17 5:38am

Graeme_Grant

v3

Add a Solution

Comments

Jochen Arndt 14-Mar-17 7:48am

You are probably using some kind of PHP chart library / module.
But without knowing which and how you use it, nobody here can help.

Please use the green 'Improve question' link to add the necessary information to your question.

User1454 14-Mar-17 11:37am

Yeah thanks!!. My mistake.. updated it..

Graeme_Grant 14-Mar-17 11:40am

"which adds +05:30" but you have asked for "-0530". Are you sure it is added???

User1454 14-Mar-17 11:45am

Hi, this is one of the datetime value I have 2017-02-18 00:00:42 in which I need only HH and mm, but in charts in tooltip it is displayed as "05:30:42". It adds "05hrs:30minutes" to all the values

1 solution

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Graeme_Grant · Answer 1 · 2017-03-14T03:24:00

Solution 1

Not knowing the lib that you are referring to, but date values can be either localized or UTC (Universal Time).

My guess is that you are passing a Localized server time where the lib is expecting a UTC time. Try converting to UTC before making the lib call.

Posted 14-Mar-17 3:24am

Graeme_Grant

Comments

User1454 14-Mar-17 11:39am

Hey @Graeme_Grant you are right!! This is my Indian time 2017-02-18 00:00:42,889 and I take only HH and mm from this for display. I will try that.. thanks

User1454 15-Mar-17 1:04am

Hi I tried the following solutions:
1. gmdate('d.m.Y H:i', strtotime('2017-02-18 00:00:42') but gives wrong date time 01.01.1970 00:00.
2. $timestamp = strtotime("00:00" - 19800); but shows wrong values

Graeme_Grant 15-Mar-17 1:16am

As I previously mentioned, I have not used that lib. Google does have API documentation for this Lib and has a specific section on Dates & Times: Dates and Times | Charts | Google Developers[^]