Here you go: # date -r 123439819723 ‘+%m/%d/%Y:%H:%M:%S’ 08/26/5881:17:48:43 In a bash script you could have something like this: if [[ “$OSTYPE” == “linux-gnu”* ]]; then dayOfWeek=$(date –date @1599032939 +”%A”) dateString=$(date –date @1599032939 +”%m/%d/%Y:%H:%M:%S”) elif [[ “$OSTYPE” == “darwin”* ]]; then dayOfWeek=$(date -r 1599032939 +%A) dateString=$(date -r 1599032939 +%m/%d/%Y:%H:%M:%S) fi
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
var someDate = new Date(dateString); someDate = someDate.getTime();
convert the string to a datetime using to_datetime and then subtract datetime 1970-1-1 and call dt.total_seconds(): In [2]: import pandas as pd import datetime as dt df = pd.DataFrame({‘date’:[‘2011-04-24 01:30:00.000’]}) df Out[2]: date 0 2011-04-24 01:30:00.000 In [3]: df[‘date’] = pd.to_datetime(df[‘date’]) df Out[3]: date 0 2011-04-24 01:30:00 In [6]: (df[‘date’] – dt.datetime(1970,1,1)).dt.total_seconds() Out[6]: 0 1303608600 … Read more
moment.unix(yourUnixEpochTime).format(‘dddd, MMMM Do, YYYY h:mm:ss A’)
Whenever doing calendrical calculations, it is almost always better to use whatever API the platform provides, such as Python’s datetime and calendar modules, or a mature high-quality library, than it is to write “simpler” code yourself. Date and calendar APIs are ugly and complicated, but that’s because real-world calendars have a lot of weird behavior. … Read more
Fixed it using substr($epoch, 0, 10) and then used the date function for anyone wondering about the 13 digit epoch times. Here is a sample code: echo date(“Y-m-d H:i:s”, substr(“1477020641000”, 0, 10)); // Result: 2016-10-20 20:30:41
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
To change the values in the database, use the UPDATE command: UPDATE MyTable SET MyColumn = datetime(MyColumn, ‘unixepoch’, ‘localtime’)