freddofrog
won 16.4k on Euro lottery :)
As you may know, Microsoft Excel uses a number-code to store dates and times
e.g. Monday 5th June 2017 16:40
In Excel this is stored as 42891.6805556
which is 42,891 days since 1st January 1900
and 58,800 divided by 86,400
(58,800 seconds out of 86,400 seconds in 24 hours).
I am trying to make sense of numbers in a database.
There are two numbers
1496676000000
1497674365000
(for what it's worth, difference is 998365000)
One of those numbers seems to be responsible for Monday 5th June 2017 16:40
Any ideas how either of those numbers will generate the date and time ?
e.g. Monday 5th June 2017 16:40
In Excel this is stored as 42891.6805556
which is 42,891 days since 1st January 1900
and 58,800 divided by 86,400
(58,800 seconds out of 86,400 seconds in 24 hours).
I am trying to make sense of numbers in a database.
There are two numbers
1496676000000
1497674365000
(for what it's worth, difference is 998365000)
One of those numbers seems to be responsible for Monday 5th June 2017 16:40
Any ideas how either of those numbers will generate the date and time ?