Menu
I have a field in my database that is stored as a timestamp, I need to output this in seconds in EPOCH time.
721
Convert from human-readable date to epochlong epoch = new java.text.SimpleDateFormat("MM/dd/yyyy HH:mm:ss").parse("01/01/1970 01:00:00").getTime() / 1000; Timestamp in seconds, remove '/1000' for milliseconds. date +%s -d"Jan 1, 1980 00:00:01" Replace '-d' with '-ud' to input in GMT/UTC time.
Technically, no. Even though epoch time is the means elapsed seconds since 1/1/70 00:00:00 the real "GMT" (UTC) is not. UTC time needed to be changed a few times to take in to account the slowing speed of the rotating earth. As everybody wrote, most people use epoch at UTC.
Epoch Time Difference FormulaMultiply the two dates' absolute difference by 86400 to get the Epoch Time in seconds – using the example dates above, is 319080600.
Supposing your timestamp is a Ruby Time object:
puts time_stamp.strftime('%s') puts time_stamp.to_i timestamp = Time.at(628232400) In case it is a DateTime object, you have the strftime and strptime methods at your disposal.
121
Returns number of seconds since epoch:
time = Time.now.to_i Returns second since epoch which includes microseconds:
time = Time.now.to_f If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With
