Chart X axis Timestamp doesn't match my Dataset timestamp

I have a named query that returns Date Time and Qty columns, which I am using in a time series chart in perspective.
I don’t know why the X axis time stamp (AM/PM) doesn’t match the time from my Data…
I am starting my data at 5AM but the X axis shows 5PM… any clue how to correct this?..

it probbaly changes it because you have a different locale than the gateway

where can I change the local time.?. I tried project properties/Perspective/General/Timezone…
different values and nothing cahnges…
I still have my X axis chart off by 1 day and 1 hour
O_o

additional ideas?.. thank you

where do fill this dataset up? because it could be that the dataset itself also already is changed

The data is coming from a Named Query, when testing the Named Query the returned data matches my SQL table…

even my Dataset matches my SQL table DateTime values… but when adding a time series chart the X axis Date-time doesn’t match my DateTime column values…

I tried other tables and different SQL servers that I hava available and the Datetime is always off in the timeseries chart…
totally lost in here… no clue what else I can do…

Thanks!

can you query to json? or does that not work for the chart?
And maybe get one date and get the timezone from it with one of these

are you running the gateway on a diffrent machine? what is the timezone on it?