# Query date and time (SQLite)

**URL:** <https://forum.inductiveautomation.com/t/query-date-and-time-sqlite/45796>\
**Category:** Ignition\
**Created:** [April 20, 2021, 8:37am UTC](https://forum.inductiveautomation.com/t/query-date-and-time-sqlite/45796 "2021-04-20T08:37:55Z")\
**Posts on this page:** 4\
**Page:** 1

<div class="post-metadata">

**Author:** ![mojoeswa](https://avatars.discourse-cdn.com/v4/letter/m/45deac/32.png) [@mojoeswa](https://forum.inductiveautomation.com/u/mojoeswa)\
**Post date:** [April 20, 2021, 8:37am UTC](https://forum.inductiveautomation.com/t/query-date-and-time-sqlite/45796/1 "2021-04-20T08:37:55Z")

</div>

Hello,  
I’m trying to run a query to retrieve tag value from an SQlite database, but t\_stamp is in integer format and I’m not able to convert to the correct date format (YYYY-MM-DD HH:MM:SS)

I have tried the following Query: SELECT datetime (t\_stamp, ‘unixepoch’) FROM sqlt\_data\_1\_2021\_04

The value I get back on t\_stamp is “NULL”  
The integer in the first row is 1617676793399

Any suggestions? What is the format for t\_stamp?

---

<div class="post-metadata">

**Author:** ![JordanCClark](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/jordancclark/32/83362_2.png) [@JordanCClark](https://forum.inductiveautomation.com/u/JordanCClark)\
**Post date:** [April 20, 2021, 9:14am UTC](https://forum.inductiveautomation.com/t/query-date-and-time-sqlite/45796/2 "2021-04-20T09:14:19Z")

</div>

try:

```sql
SELECT datetime(t_stamp/1000, 'unixepoch');

```

---

<div class="post-metadata">

**Author:** ![mojoeswa](https://avatars.discourse-cdn.com/v4/letter/m/45deac/32.png) [@mojoeswa](https://forum.inductiveautomation.com/u/mojoeswa)\
**Post date:** [April 20, 2021, 9:35am UTC](https://forum.inductiveautomation.com/t/query-date-and-time-sqlite/45796/3 "2021-04-20T09:35:30Z")

</div>

That worked! thx alot!!

---

<div class="post-metadata">

**Author:** ![Ivan\_Habib\_Sierra\_Fe](https://avatars.discourse-cdn.com/v4/letter/i/22d042/32.png) [@Ivan\_Habib\_Sierra\_Fe](https://forum.inductiveautomation.com/u/Ivan_Habib_Sierra_Fe)\
**Post date:** [March 7, 2022, 7:49pm UTC](https://forum.inductiveautomation.com/t/query-date-and-time-sqlite/45796/4 "2022-03-07T19:49:18Z")

</div>

> [@mojoeswa](#):
>
> SELECT datetime (t\_stamp, ‘unixepoch’) FROM sqlt\_data\_1\_2021\_04

Hi I try this solution but I still getting NULL Values, did something change?  
SELECT datetime(sqlt\_data\_1\_2022\_03.t\_stamp/1000, 'unixepoch')  
FROM sqlt\_data\_1\_2022\_03