# Date formatting question **URL:** \ **Category:** Ignition\ **Created:** [January 20, 2023, 4:03pm UTC](https://forum.inductiveautomation.com/t/date-formatting-question/68856 "2023-01-20T16:03:10Z")\ **Posts on this page:** 3\ **Page:** 1
**Author:** ![Parth\_Pandya](https://avatars.discourse-cdn.com/v4/letter/p/5f9b8f/32.png) [@Parth\_Pandya](https://forum.inductiveautomation.com/u/Parth_Pandya)\ **Post date:** [January 20, 2023, 4:03pm UTC](https://forum.inductiveautomation.com/t/date-formatting-question/68856/1 "2023-01-20T16:03:10Z")
![dataset date issue](https://us1.discourse-cdn.com/inductiveautomation/original/3X/0/1/0196d9b198dbed06632c5032939a5c61baea27ee.png) i am doing simple query select starttime endtime from table in detaset editor ia m getting dates and time with second but not in window table its not showing seconds any help? how i can get second? do i need any script in table property chnage? ---
**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:** [January 20, 2023, 4:41pm UTC](https://forum.inductiveautomation.com/t/date-formatting-question/68856/2 "2023-01-20T16:41:56Z")
You need to change the 'Date Format' property in the column customizer for your table. Double click the table in the designer and you should get the ability to change the table's attributes. ---
**Author:** ![Parth\_Pandya](https://avatars.discourse-cdn.com/v4/letter/p/5f9b8f/32.png) [@Parth\_Pandya](https://forum.inductiveautomation.com/u/Parth_Pandya)\ **Post date:** [January 20, 2023, 5:44pm UTC](https://forum.inductiveautomation.com/t/date-formatting-question/68856/3 "2023-01-20T17:44:09Z")
ooh sorry i totally forgot this. my bad thanks PGriffith