Get the epoch time and add it as a new column

Question

Get the epoch time and add it as a new column

I have the following tab separated input file, with timestamps in UTC. How can I calculate the epoch time an add it as a new column? It is a large file with over 60MM rows.

a   b

0   2020-03-03 15:46:52

1   2020-03-02 11:05:17

Output:

a   b                   c  

0   2020-03-03 15:46:52 1583279212

1   2020-03-02 11:05:17 1583175917

date text-processing linux

3 years ago by vishaljlf39

1 Answer

Login / Signup to Answer the Question.

Login Signup

**Bharatv4tg1** · Answer 1 · 2021-12-10T07:30:05

I'm not sure how suitable it will be for large files, but you try do something like this with Miller

$ TZ=UTC mlr --pprint --fs tab put -S '$c = strftime(strptime($b,"%Y-%m-%d %H:%M:%S"),"%s")' file

a   b                                   c

0   2020-03-03 15:46:52 1583250412

1   2020-03-02 11:05:17 1583147117

(although I just noticed it appears to screw up the header alignment when the OFS is tab ...).

C TUTORIAL

C PROGRAMS

INTERVIEW TESTS

EXECUTE CODE

C++ TUTORIAL

C++ PROGRAMS

INTERVIEW TESTS

EXECUTE CODE

PYTHON TUTORIAL

PYTHON HOW TOS

INTERVIEW TESTS

EXECUTE CODE

JAVA TUTORIAL

JAVA CODE EXAMPLES

SPRING TUTORIAL

MORE IN JAVA

COMPUTER ARCHITECTURE

COMPUTER NETWORK

OPERATING SYSTEM

DBMS & SQL

PL/SQL

MongoDB

EXECUTE SQL

ANDROID DEVELOPMENT

GO LANGUAGE

LINUX

DOCKER

HTML TAGS (A to Z)

CSS REFERENCES

SASS/SCSS

KOTLIN

GAME DEVELOPMENT

PHP

GIT GUIDE

JAVASCRIPT

ADVANCED DSA

Get the epoch time and add it as a new column

1 Answer

Login / Signup to Answer the Question.