# Sql Lite database table t\_stamp format **URL:** \ **Category:** Ignition\ **Created:** [October 13, 2022, 10:07am UTC](https://forum.inductiveautomation.com/t/sql-lite-database-table-t-stamp-format/65162 "2022-10-13T10:07:55Z")\ **Posts on this page:** 8\ **Page:** 1
**Author:** ![R\_P](https://avatars.discourse-cdn.com/v4/letter/r/aca169/32.png) [@R\_P](https://forum.inductiveautomation.com/u/R_P)\ **Post date:** [October 13, 2022, 10:07am UTC](https://forum.inductiveautomation.com/t/sql-lite-database-table-t-stamp-format/65162/1 "2022-10-13T10:07:55Z")
Hi All, I m generating report by pulling data from sql database table. t\_stamp value showing long integer (epoch/ unix format). How to convert it to data & time format? ---
**Author:** ![jeremy.lecoutre](https://avatars.discourse-cdn.com/v4/letter/j/3e96dc/32.png) [@jeremy.lecoutre](https://forum.inductiveautomation.com/u/jeremy.lecoutre)\ **Post date:** [October 13, 2022, 10:54am UTC](https://forum.inductiveautomation.com/t/sql-lite-database-table-t-stamp-format/65162/2 "2022-10-13T10:54:17Z")
you can use the scripting function system.date.fromMillis(t\_stamp) and system.date.format(date,"YYYY-MM-dd HH:mm") [https://docs.inductiveautomation.com/display/DOC81/system.date](https://docs.inductiveautomation.com/display/DOC81/system.date) you have same method with expression too [https://docs.inductiveautomation.com/display/DOC81/Date+and+Time](https://docs.inductiveautomation.com/display/DOC81/Date+and+Time) ---
**Author:** ![pascal.fragnoud](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/pascal.fragnoud/32/24728_2.png) [@pascal.fragnoud](https://forum.inductiveautomation.com/u/pascal.fragnoud)\ **Post date:** [October 13, 2022, 11:50am UTC](https://forum.inductiveautomation.com/t/sql-lite-database-table-t-stamp-format/65162/3 "2022-10-13T11:50:48Z")
I don't use reports so I don't know if you can modify the query, but if you can you should convert directly there: ```sql select from_unixtime(t_stamp / 1000) date from table ``` ![image](https://us1.discourse-cdn.com/inductiveautomation/original/3X/a/8/a8ea93aba43e93dd66f65dc642947a101164d018.png) ---
**Author:** ![R\_P](https://avatars.discourse-cdn.com/v4/letter/r/aca169/32.png) [@R\_P](https://forum.inductiveautomation.com/u/R_P)\ **Post date:** [October 13, 2022, 12:13pm UTC](https://forum.inductiveautomation.com/t/sql-lite-database-table-t-stamp-format/65162/4 "2022-10-13T12:13:54Z")
Hi, Thanks for reply. I m getting error below ![image](https://us1.discourse-cdn.com/inductiveautomation/original/3X/5/4/54a9418c9b045740c80069234df8ac76acca027e.png) ---
**Author:** ![pascal.fragnoud](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/pascal.fragnoud/32/24728_2.png) [@pascal.fragnoud](https://forum.inductiveautomation.com/u/pascal.fragnoud)\ **Post date:** [October 13, 2022, 12:21pm UTC](https://forum.inductiveautomation.com/t/sql-lite-database-table-t-stamp-format/65162/5 "2022-10-13T12:21:01Z")
That's because it's sqlite. You'll need to find the equivalent in the doc. [https://sqlite.org/lang\_datefunc.html](https://sqlite.org/lang_datefunc.html) ---
**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:** [October 13, 2022, 12:25pm UTC](https://forum.inductiveautomation.com/t/sql-lite-database-table-t-stamp-format/65162/6 "2022-10-13T12:25:59Z")
> [@jeremy.lecoutre](#): > > system.date.format Don't use this until/unless you need to. Pass `java.util.Date` objects around. Convert to string for display only, and only if Ignition's components won't do it for you. (A component's native conversion will handle client time zones and locales for you.) ---
**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:** [October 13, 2022, 12:28pm UTC](https://forum.inductiveautomation.com/t/sql-lite-database-table-t-stamp-format/65162/7 "2022-10-13T12:28:27Z")
You really should avoid SQLite for actual database connections. It is a single-threaded DB intended for very light duty (configuration file type tasks) and is missing many SQL features. If you need something free, install PostgreSQL or MariaDB (or MySQL if you must). ---
**Author:** ![jeremy.lecoutre](https://avatars.discourse-cdn.com/v4/letter/j/3e96dc/32.png) [@jeremy.lecoutre](https://forum.inductiveautomation.com/u/jeremy.lecoutre)\ **Post date:** [October 13, 2022, 2:35pm UTC](https://forum.inductiveautomation.com/t/sql-lite-database-table-t-stamp-format/65162/8 "2022-10-13T14:35:04Z")
yes i know, it's for that i prefer work with date object and not with str format. But the question is > How to convert it to data & time format? But thank tou for this precision 😉