search

apache / ignite

Apache Ignite
https://ignite.apache.org/
Apache License 2.0
4.77k stars 1.9k forks source link

Question: DateTime Conversion Issue with different server #11546

Open ratadepally opened 6 days ago

ratadepally commented 6 days ago

Hi

We are currently facing an issue with Date Time Conversion function. We used below query to convert Date time string to timestamp.

SELECT CONVERT('2022-09-09 00:00:00', TIMESTAMP);

When we ran the query on Server1(Ubuntu Linux Server) it gave us below output.

image

and when we ran same query on Server2(Oracle Linux Server ) it gave different result.

image

What we are expecting here is for the date to not change as we are just converting Date String to Timestamp.

Does Server distro really matter with these type of Ignite date conversion? Please suggest

ratadepally commented 3 days ago

Hi - Any suggestions or comments on this please?

ygerzhedovich commented 14 hours ago

@ratadepally It doesn't matter which distro you used. It just Java application which run in JVM. What here can be matter - it's timezone on both of servers or parameters JVM related to timezone.

ratadepally commented 9 hours ago

Hi @ygerzhedovich - thank you for the update.