As far back as commit c64b9b8 (git 0.99, May 2005), time has always been referred as <date> Date in ‘seconds since epoch‘ commit 6eb8ae0 defines date as an unsigned long since April 2005. TLDR; date before unix epoch can be stored, but cannot be sure to be correctly represented. But that has evolved since 2014 … Read more
There is an interesting twist when you want to know the Unix Epoch time in .Net on a Windows system. For nearly all practical cases and assuming the current time is past the Unix Epoch you could indeed take System.TimeSpan timeDifference = DateTime.UTCNow – new DateTime(1970, 1, 1, 0, 0, 0, DateTimeKind.Utc); long unixEpochTime = … Read more
Easy, first add whole days, then add the remaining ms. There are 86,400,000 milliseconds in a day. declare @unixTS bigint set @unixTS = 1359016610667 select dateadd(ms, @unixTS%(3600*24*1000), dateadd(day, @unixTS/(3600*24*1000), ‘1970-01-01 00:00:00.0’) ) The result is 2013-01-24 08:36:50.667
You can use the Joda Time library to do this pretty easily – I use it for anything time related other than using the standard Java Date and Calendar classes. Take a look at the example below using the library: MutableDateTime epoch = new MutableDateTime(); epoch.setDate(0); //Set to Epoch time DateTime now = new DateTime(); … Read more
It is a function of both the specific clock the time_point refers to, and the implementation of that clock. The standard specifies three different clocks: system_clock steady_clock high_resolution_clock And the standard does not specify the epoch for any of these clocks. Programmers (you) can also author their own clocks, which may or may not specify … Read more
First, convert it to a datetime object with second precision (floored, not rounded): >>> from datetime import datetime >>> dt = datetime.fromtimestamp(1360287003083988472 // 1000000000) >>> dt datetime.datetime(2013, 2, 7, 17, 30, 3) Then to make it human-readable, use the strftime() method on the object you get back: >>> s = dt.strftime(‘%Y-%m-%d %H:%M:%S’) >>> s ‘2013-02-07 … Read more
In Oracle, adding X to a DATE will return you a DATE X days later. If ESTIMATEDENDTIME is milliseconds since Epoch then you could do DATE ‘1970-01-01’ + ( 1 / 24 / 60 / 60 / 1000) * ESTIMATEDENDTIME and then use to_char to achieve the correct format of the resulting date. e.g: SELECT … Read more
Your epoch value 1389422614485 seems like having the millisecond precision. So you need to use some mysql mathematical functions along with from_unixtime() for generating human readable format. mysql> select from_unixtime(floor(1389422614485/1000)); +——————————————+ | from_unixtime(floor(1389422614485/1000)) | +——————————————+ | 2014-01-11 12:13:34 | +——————————————+ Update July 2020: As of MySQL 8.0, the floor function is no longer necessary when … Read more
Look into SimpleDateFormat SimpleDateFormat sdf = new SimpleDateFormat(“dd/MM/yyyy”); sdf.format(new Date(myTimeAsLong));