# Datetime2 format in EasyChart **URL:** \ **Category:** Ignition\ **Created:** [March 29, 2011, 7:56am UTC](https://forum.inductiveautomation.com/t/datetime2-format-in-easychart/2815 "2011-03-29T07:56:34Z")\ **Posts on this page:** 13\ **Page:** 1
**Author:** ![vahterto](https://avatars.discourse-cdn.com/v4/letter/v/e68b1a/32.png) [@vahterto](https://forum.inductiveautomation.com/u/vahterto)\ **Post date:** [March 29, 2011, 7:56am UTC](https://forum.inductiveautomation.com/t/datetime2-format-in-easychart/2815/1 "2011-03-29T07:56:34Z")
Hi Is it possible to use MSSQL server datetime2 format in EasyChart DB pens? Now it seems to try use datetime even error message says that format should be date? We would like to get millisecond resolution to trend from our data and easiest way is to use datetime2. Br Tommi Vahtera THT Control Oy ---
**Author:** ![Carl.Gould](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/carl.gould/32/7262_2.png) [@Carl.Gould](https://forum.inductiveautomation.com/u/Carl.Gould)\ **Post date:** [March 31, 2011, 8:16pm UTC](https://forum.inductiveautomation.com/t/datetime2-format-in-easychart/2815/2 "2011-03-31T20:16:07Z")
All Java Dates have millisecond resolution, so the DB pens themselves are already set up to expect milliseconds. Is the table itself configured with the correct datatypes? What error are you getting exactly? ---
**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:** [August 8, 2017, 12:12am UTC](https://forum.inductiveautomation.com/t/datetime2-format-in-easychart/2815/3 "2017-08-08T00:12:22Z")
I have found this as well. Ignition doesn’t seem to recognise the T-SQL datetime2 format as a datetime. I’m pulling data from a query into a table with datetime2 fields, and trying to format the display of them using the object customiser, but they won’t change format. If I change the field format to datetime, then it works… I would much rather use the newer datetime2 format. Is this a known issue? ---
**Author:** ![paul-griffith](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/paul-griffith/32/37249_2.png) [@paul-griffith](https://forum.inductiveautomation.com/u/paul-griffith)\ **Post date:** [August 8, 2017, 4:00pm UTC](https://forum.inductiveautomation.com/t/datetime2-format-in-easychart/2815/4 "2017-08-08T16:00:14Z")
First question: Are you using the latest release of Microsoft’s JDBC driver? The version Ignition ships with is older for compatibility reasons, so I would try updating. ---
**Author:** ![silverbacknet](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/silverbacknet/32/7385_2.png) [@silverbacknet](https://forum.inductiveautomation.com/u/silverbacknet)\ **Post date:** [March 22, 2019, 9:01pm UTC](https://forum.inductiveautomation.com/t/datetime2-format-in-easychart/2815/5 "2019-03-22T21:01:52Z")
Oof, when you say old, you aren’t kidding. I just checked the version and even the latest release has 2.0.1803.100 from 2009. I’ll copy the newer one in there and cross my fingers that it works. ---
**Author:** ![ross\_warwick](https://avatars.discourse-cdn.com/v4/letter/r/3bc359/32.png) [@ross\_warwick](https://forum.inductiveautomation.com/u/ross_warwick)\ **Post date:** [April 25, 2022, 2:14pm UTC](https://forum.inductiveautomation.com/t/datetime2-format-in-easychart/2815/6 "2022-04-25T14:14:23Z")
A while ago now but did upgrading the version work? If so, which version did you upgrade to? ---
**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 25, 2022, 9:30pm UTC](https://forum.inductiveautomation.com/t/datetime2-format-in-easychart/2815/7 "2022-04-25T21:30:51Z")
Yes it does work. Just upgrade to the latest driver available for the version of Java you’re using (8 for 7.9 and 11 for 8.x) ---
**Author:** ![ross\_warwick](https://avatars.discourse-cdn.com/v4/letter/r/3bc359/32.png) [@ross\_warwick](https://forum.inductiveautomation.com/u/ross_warwick)\ **Post date:** [April 26, 2022, 9:23am UTC](https://forum.inductiveautomation.com/t/datetime2-format-in-easychart/2815/8 "2022-04-26T09:23:56Z")
I’m creating a project on someone else’s system, it’s Ignition 7.6.6. They have said I can update the SQL Server JDBC driver but I wanted to be sure before I rocked the boat ![image](https://us1.discourse-cdn.com/inductiveautomation/original/3X/0/f/0fdd7d13a8720024b13e20c2d5e16cd6c178de72.png) ---
**Author:** ![pturmel](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/pturmel/32/3295_2.png) [@pturmel](https://forum.inductiveautomation.com/u/pturmel)\ **Post date:** [April 26, 2022, 12:32pm UTC](https://forum.inductiveautomation.com/t/datetime2-format-in-easychart/2815/9 "2022-04-26T12:32:01Z")
> [@ross\_warwick](#): > > it’s Ignition 7.6.6. Danger Will Robinson!!! The newest drivers will need a fairly modern java 8. A fairly modern java 8 may not run such an ancient version of Ignition. Make a complete image backup of that gateway (OS level backup) so you can revert when (likely) this blows up in your face. If you succeed, please report back. So we can marvel at your accomplishment.. /: ---
**Author:** ![ross\_warwick](https://avatars.discourse-cdn.com/v4/letter/r/3bc359/32.png) [@ross\_warwick](https://forum.inductiveautomation.com/u/ross_warwick)\ **Post date:** [April 26, 2022, 12:36pm UTC](https://forum.inductiveautomation.com/t/datetime2-format-in-easychart/2815/10 "2022-04-26T12:36:10Z")
Thanks for the responses. From @nminchin response I used a Java 7 driver. I tried mssql-jdbc-6.2.2.jre7.jar which worked. The Easy Chart now works with datetime2 ---
**Author:** ![pturmel](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/pturmel/32/3295_2.png) [@pturmel](https://forum.inductiveautomation.com/u/pturmel)\ **Post date:** [April 26, 2022, 12:37pm UTC](https://forum.inductiveautomation.com/t/datetime2-format-in-easychart/2815/11 "2022-04-26T12:37:09Z")
Ah, good to know that JRE7 and DATETIME2 support overlapped. ---
**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 26, 2022, 12:37pm UTC](https://forum.inductiveautomation.com/t/datetime2-format-in-easychart/2815/12 "2022-04-26T12:37:11Z")
Also, if it wasn’t obvious from @pturmel 's reply, you should really upgrade… Like yesterday… ---
**Author:** ![ross\_warwick](https://avatars.discourse-cdn.com/v4/letter/r/3bc359/32.png) [@ross\_warwick](https://forum.inductiveautomation.com/u/ross_warwick)\ **Post date:** [April 26, 2022, 1:50pm UTC](https://forum.inductiveautomation.com/t/datetime2-format-in-easychart/2815/13 "2022-04-26T13:50:06Z")
Not my installation. An outside contractor set it up and supports it. I’m just creating a quick front end for a new machine.