A timestamp is the elapsed time since Epoch time (01/01/1970), so basically we have to convert this time in days, and add the epoch time, to get a valid format for any Excel like spreadsheet software. From a timestamp in milliseconds (ex: 1488380243994) use this formula: =A1/1000/86400+25569 with this formater: yyyy-mm-dd hh:mm:ss.000 From a timestamp in seconds (ex: 1488380243) use this ...
When you divide it by the number of seconds in a minute (60) you get: 1440 minutes (or 24h, one day) Tip: you can query Google: 86400 seconds in minutes and it calculates your answer (works for ...
Any time the constant 86400 appears in your code, there is a good chance you're doing something that's not quite right. And things get even more complicated when you need to determine the number of seconds in a week, a month, a year, a quarter, and so on. Learn to use those calendar libraries.
If the number of seconds entered by the user is greater than or equal to 86400, the program should display the number of days in that many seconds. What I have so far:
86400 is the number of seconds in the day 2209075200 is the number of seconds between 1900-01-01 and 1970-01-01 which are the base dates for Excel and Unix timestamps.
For more informaton about Oracle DATE datatype look here. And 86400 is a day in terms of seconds: 60 seconds x 60 minutes x 24 hours = 86400 You use this to add a new day!
Now if you also note that we have 86400 seconds per day (24 hours x60 minutes x60 seconds) and you will understand what this formula does: A1/86400 converts seconds to days and +25569 adjusts for the offset between what is zero-time for Unix and what is zero-time for Excel.
How many days are in 86400 seconds? One day is equal to 60 x 60 x 24 = 86400 seconds. Therefore, 86400 seconds is equal to 86400/86400 = 1 day.