A solution is to use the PARSE_DATETIME function. https://calcite.apache.org/docs/reference.html#dialect-specific-operators
Mihai ________________________________ From: Mahesh Mandhare <[email protected]> Sent: Tuesday, September 16, 2025 3:25 AM To: [email protected] <[email protected]> Cc: Mahadev Mishal <[email protected]>; Vilas Dharma Suryawanshi <[email protected]> Subject: Support ISO date format Hello Team, Is there any way where we can add support for ISO date format containing characters T and Z like “YYYY-MM-DDTHH:MI:SS.FFZ“ We are trying to run sample query select * from public.assets where createdTime > '2024-01-01T23:00:00.000Z'; Sample output of select * query [cid:22123f12-c997-4c43-a2fa-07845db0bd42] [cid:9792d59b-4544-4a4f-a178-69c7da33bcd2]<https://www.rockwellautomation.com/> Mahesh Sopan Mandhare TECH LEAD A-Wing Mississippi Bldg Embassy Tech Zone, Hinjewadi P2, Pune India M +919665868428 [Rockwell Automation Facebook]<https://www.facebook.com/ROKAutomation> [Rockwell Automation Instagram] <https://www.instagram.com/rokautomation/> [Rockwell Automation LinkedIn] <http://www.linkedin.com/company/rockwell-automation> [Rockwell Automation Twitter] <https://twitter.com/ROKAutomation>
