I am trying to understand structure of SQLite table which I received to study, there is field called UPDATETIME which contains number 638737362915677310, this number should be datetime as of 29JAN2025 08:30 AM (+- few minutes).

Do you have any idea which expression of datetime it is? For number of seconds from epoch it is too big, even for miliseconds.

Many thanks for your ideas.

V

I am trying to understand structure of SQLite table which I received to study, there is field called UPDATETIME which contains number 638737362915677310, this number should be datetime as of 29JAN2025 08:30 AM (+- few minutes).

Do you have any idea which expression of datetime it is? For number of seconds from epoch it is too big, even for miliseconds.

Many thanks for your ideas.

V

• sqlite

Share Improve this question Follow asked Jan 29 at 7:37 Vladimir BuzalkaVladimir Buzalka 6199 bronze badges 1

• it looks like this is a composite field (apart from the date and time, which are apparently the seconds since 0001.01.01) you have other data: 63873736291_5677310 – mr mcwolf Commented Jan 29 at 10:19

Add a comment  | 

1 Answer 1

Sorted by: Reset to default 1

Take a look here: Epoch Converter.

If we remove one zero (638737362915677310 → 63873736291567731), we get GMT: Wednesday 29 January 2025 08:31:31

This suggests that the number likely represents the number of seconds since 0001-01-01.