change date/time format from yyyymmddHHMMss to dd/mm/yyyy HH:MM:ss

up vote
0
down vote

favorite

How do I change date/time format from yyyymmddHHMMss to dd/mm/yyyy HH:MM:ss

which is displayed as an output (eg. JOBNAME1 STARTED AT 20180904152402)

from a command...

grep JOBNAME1 | sed -e s/|/ /g | awk print $3,$7,$8,$9 |sort -r -k 4

edited Sep 5 at 15:13

Jeff Schaller

33k849111

asked Sep 5 at 14:59

Colin

Answers to this question unix.stackexchange.com/questions/89568/â€¦ should get you on the right track.
â€“Â Mr Shunz
Sep 5 at 15:22

1

ick, your desired date format is ambiguous
â€“Â glenn jackman
Sep 5 at 19:29

add a commentÂ |Â

up vote
0
down vote

favorite

How do I change date/time format from yyyymmddHHMMss to dd/mm/yyyy HH:MM:ss

which is displayed as an output (eg. JOBNAME1 STARTED AT 20180904152402)

from a command...

grep JOBNAME1 | sed -e s/|/ /g | awk print $3,$7,$8,$9 |sort -r -k 4

edited Sep 5 at 15:13

Jeff Schaller

33k849111

asked Sep 5 at 14:59

Colin

Answers to this question unix.stackexchange.com/questions/89568/â€¦ should get you on the right track.
â€“Â Mr Shunz
Sep 5 at 15:22

1

ick, your desired date format is ambiguous
â€“Â glenn jackman
Sep 5 at 19:29

add a commentÂ |Â

up vote
0
down vote

favorite

How do I change date/time format from yyyymmddHHMMss to dd/mm/yyyy HH:MM:ss

which is displayed as an output (eg. JOBNAME1 STARTED AT 20180904152402)

from a command...

grep JOBNAME1 | sed -e s/|/ /g | awk print $3,$7,$8,$9 |sort -r -k 4

edited Sep 5 at 15:13

Jeff Schaller

33k849111

asked Sep 5 at 14:59

Colin

How do I change date/time format from yyyymmddHHMMss to dd/mm/yyyy HH:MM:ss

which is displayed as an output (eg. JOBNAME1 STARTED AT 20180904152402)

from a command...

grep JOBNAME1 | sed -e s/|/ /g | awk print $3,$7,$8,$9 |sort -r -k 4

shell-script command-line scripting date aix

edited Sep 5 at 15:13

Jeff Schaller

33k849111

asked Sep 5 at 14:59

Colin

edited Sep 5 at 15:13

Jeff Schaller

33k849111

asked Sep 5 at 14:59

Colin

edited Sep 5 at 15:13

Jeff Schaller

33k849111

edited Sep 5 at 15:13

Jeff Schaller

33k849111

edited Sep 5 at 15:13

Jeff Schaller

33k849111

asked Sep 5 at 14:59

Colin

asked Sep 5 at 14:59

Colin

asked Sep 5 at 14:59

Colin

Answers to this question unix.stackexchange.com/questions/89568/â€¦ should get you on the right track.
â€“Â Mr Shunz
Sep 5 at 15:22

1

ick, your desired date format is ambiguous
â€“Â glenn jackman
Sep 5 at 19:29

add a commentÂ |Â

Answers to this question unix.stackexchange.com/questions/89568/â€¦ should get you on the right track.
â€“Â Mr Shunz
Sep 5 at 15:22

1

ick, your desired date format is ambiguous
â€“Â glenn jackman
Sep 5 at 19:29

Answers to this question unix.stackexchange.com/questions/89568/â€¦ should get you on the right track.
â€“Â Mr Shunz
Sep 5 at 15:22

ick, your desired date format is ambiguous
â€“Â glenn jackman
Sep 5 at 19:29

add a commentÂ |Â

2 Answers
2

active

oldest

votes

up vote
0
down vote

Painfully ugly awk method:

echo JOBNAME1 STARTED AT 20180904152402 | awk '$4=substr($4,7,2)"/"substr($4,5,2)"/"substr($4,1,4)" "substr($4,9,2)":"substr($4,11,2)":"substr($4,13,2); print'

answered Sep 5 at 15:13

Jeff Schaller

33k849111

Yay....it worked...thanx alot for your help....
â€“Â Colin
Sep 11 at 15:06

add a commentÂ |Â

up vote
0
down vote

d='([[:digit:]]2)'
sed "s|$d$d$d$d$d$d$d|4/3/12 5:6:7|g"

So for your code:

d='([[:digit:]]2)'
awk -F'|' '/JOBNAME1/ print $3,$7,$8,$9' | sort -rk 4 |
 sed "s|$d$d$d$d$d$d$d|4/3/12 5:6:7|g"

edited Sep 5 at 15:16

answered Sep 5 at 15:09

StÃ©phane Chazelas

286k53528866

add a commentÂ |Â

Your Answer

StackExchange.ready(function()
var channelOptions =
tags: "".split(" "),
id: "106"
;
initTagRenderer("".split(" "), "".split(" "), channelOptions);

StackExchange.using("externalEditor", function()
// Have to fire editor after snippets, if snippets enabled
if (StackExchange.settings.snippets.snippetsEnabled)
StackExchange.using("snippets", function()
createEditor();
);

else
createEditor();

);

function createEditor()
StackExchange.prepareEditor(
heartbeatType: 'answer',
convertImagesToLinks: false,
noModals: false,
showLowRepImageUploadWarning: true,
reputationToPostImages: null,
bindNavPrevention: true,
postfix: "",
onDemand: true,
discardSelector: ".discard-answer"
,immediatelyShowMarkdownHelp:true
);

);

draft saved

draft discarded

StackExchange.ready(
function ()
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2funix.stackexchange.com%2fquestions%2f467037%2fchange-date-time-format-from-yyyymmddhhmmss-to-dd-mm-yyyy-hhmmss%23new-answer', 'question_page');

);

Post as a guest

Name

2 Answers
2

active

oldest

votes

2 Answers
2

active

oldest

votes

up vote
0
down vote

Painfully ugly awk method:

echo JOBNAME1 STARTED AT 20180904152402 | awk '$4=substr($4,7,2)"/"substr($4,5,2)"/"substr($4,1,4)" "substr($4,9,2)":"substr($4,11,2)":"substr($4,13,2); print'

answered Sep 5 at 15:13

Jeff Schaller

33k849111

Yay....it worked...thanx alot for your help....
â€“Â Colin
Sep 11 at 15:06

add a commentÂ |Â

up vote
0
down vote

Painfully ugly awk method:

echo JOBNAME1 STARTED AT 20180904152402 | awk '$4=substr($4,7,2)"/"substr($4,5,2)"/"substr($4,1,4)" "substr($4,9,2)":"substr($4,11,2)":"substr($4,13,2); print'

answered Sep 5 at 15:13

Jeff Schaller

33k849111

Yay....it worked...thanx alot for your help....
â€“Â Colin
Sep 11 at 15:06

add a commentÂ |Â

up vote
0
down vote

Painfully ugly awk method:

echo JOBNAME1 STARTED AT 20180904152402 | awk '$4=substr($4,7,2)"/"substr($4,5,2)"/"substr($4,1,4)" "substr($4,9,2)":"substr($4,11,2)":"substr($4,13,2); print'

answered Sep 5 at 15:13

Jeff Schaller

33k849111

Painfully ugly awk method:

echo JOBNAME1 STARTED AT 20180904152402 | awk '$4=substr($4,7,2)"/"substr($4,5,2)"/"substr($4,1,4)" "substr($4,9,2)":"substr($4,11,2)":"substr($4,13,2); print'

answered Sep 5 at 15:13

Jeff Schaller

33k849111

answered Sep 5 at 15:13

Jeff Schaller

33k849111

answered Sep 5 at 15:13

Jeff Schaller

33k849111

answered Sep 5 at 15:13

Jeff Schaller

33k849111

Yay....it worked...thanx alot for your help....
â€“Â Colin
Sep 11 at 15:06

add a commentÂ |Â

Yay....it worked...thanx alot for your help....
â€“Â Colin
Sep 11 at 15:06

Yay....it worked...thanx alot for your help....
â€“Â Colin
Sep 11 at 15:06

add a commentÂ |Â

up vote
0
down vote

d='([[:digit:]]2)'
sed "s|$d$d$d$d$d$d$d|4/3/12 5:6:7|g"

So for your code:

d='([[:digit:]]2)'
awk -F'|' '/JOBNAME1/ print $3,$7,$8,$9' | sort -rk 4 |
 sed "s|$d$d$d$d$d$d$d|4/3/12 5:6:7|g"

edited Sep 5 at 15:16

answered Sep 5 at 15:09

286k53528866

add a commentÂ |Â

up vote
0
down vote

d='([[:digit:]]2)'
sed "s|$d$d$d$d$d$d$d|4/3/12 5:6:7|g"

So for your code:

d='([[:digit:]]2)'
awk -F'|' '/JOBNAME1/ print $3,$7,$8,$9' | sort -rk 4 |
 sed "s|$d$d$d$d$d$d$d|4/3/12 5:6:7|g"

edited Sep 5 at 15:16

answered Sep 5 at 15:09

286k53528866

add a commentÂ |Â

up vote
0
down vote

d='([[:digit:]]2)'
sed "s|$d$d$d$d$d$d$d|4/3/12 5:6:7|g"

So for your code:

d='([[:digit:]]2)'
awk -F'|' '/JOBNAME1/ print $3,$7,$8,$9' | sort -rk 4 |
 sed "s|$d$d$d$d$d$d$d|4/3/12 5:6:7|g"

edited Sep 5 at 15:16

answered Sep 5 at 15:09

286k53528866

d='([[:digit:]]2)'
sed "s|$d$d$d$d$d$d$d|4/3/12 5:6:7|g"

So for your code:

d='([[:digit:]]2)'
awk -F'|' '/JOBNAME1/ print $3,$7,$8,$9' | sort -rk 4 |
 sed "s|$d$d$d$d$d$d$d|4/3/12 5:6:7|g"

edited Sep 5 at 15:16

answered Sep 5 at 15:09

286k53528866

edited Sep 5 at 15:16

answered Sep 5 at 15:09

286k53528866

answered Sep 5 at 15:09

286k53528866

answered Sep 5 at 15:09

286k53528866

add a commentÂ |Â

draft saved

draft discarded

draft saved

draft discarded

Post as a guest

Name

搜尋此網誌

mjhjmtu