# Date format on Date Range is showing milliseconds causing sql query to fail **URL:** \ **Category:** Ignition\ **Created:** [April 14, 2021, 4:32pm UTC](https://forum.inductiveautomation.com/t/date-format-on-date-range-is-showing-milliseconds-causing-sql-query-to-fail/45600 "2021-04-14T16:32:54Z")\ **Posts on this page:** 3\ **Page:** 1
**Author:** ![francisco.romero](https://avatars.discourse-cdn.com/v4/letter/f/91b2a8/32.png) [@francisco.romero](https://forum.inductiveautomation.com/u/francisco.romero)\ **Post date:** [April 14, 2021, 4:32pm UTC](https://forum.inductiveautomation.com/t/date-format-on-date-range-is-showing-milliseconds-causing-sql-query-to-fail/45600/1 "2021-04-14T16:32:54Z")
Hi I am using Ignition 8.1.4 and I have a table pulling data from the database, I am trying to filter the query by date range, so I put a Date Range component and have my query like this: SELECT BATCH FROM BATCHES WHERE ACTUALSTARTDATE \>= ‘{Root Container.Power Table.startDate}’, but the date format of the component is giving back the following: ‘2021-03-25 23:59:59.999’ Is it possible to remove the .999 milliseconds? That is causing my query to fail. Thanks for the feedback ---
**Author:** ![nminchin](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/nminchin/32/6911_2.png) [@nminchin](https://forum.inductiveautomation.com/u/nminchin)\ **Post date:** [April 15, 2021, 11:37pm UTC](https://forum.inductiveautomation.com/t/date-format-on-date-range-is-showing-milliseconds-causing-sql-query-to-fail/45600/2 "2021-04-15T23:37:22Z")
What sql database are you using? ---
**Author:** ![francisco.romero](https://avatars.discourse-cdn.com/v4/letter/f/91b2a8/32.png) [@francisco.romero](https://forum.inductiveautomation.com/u/francisco.romero)\ **Post date:** [April 16, 2021, 1:57am UTC](https://forum.inductiveautomation.com/t/date-format-on-date-range-is-showing-milliseconds-causing-sql-query-to-fail/45600/3 "2021-04-16T01:57:09Z")
I am using oracle 12