Shell script date TZ format to Unix timestamp

Question

When using the AWS get-metric-statistics command, the following timestamp format is returned.

2021-06-23T09:48:00Z

This time is in UTC 0, and I want to convert this value to a unix timestamp In Shell Script.
I tried a lot of this and that, but it didn't work.
So, I ask for your help... Thank you.

What I tried
utctimestamp=`TZ=UTC date -d "$timestamp" +%s `
=> date: invalid date ‘"2021-06-23T10:12:00Z"’

utctimestamp=$(TZ="UTC" date -j -f "+%Y-%m-%dT%H:%M:%SZ" "$timestamp" "+%s")
=> date: invalid option -- 'j'

utctimestamp=`date -d -u "$timestamp" +%s `
=> date: invalid date ‘"2021-06-23T10:12:00Z"’

and so on..

What did you try? Please post it. Do you want the value in EPOCH? — Inian
– Inian, Commented Jun 23, 2021 at 10:11
stackoverflow.com/questions/21778251/… stackoverflow.com/questions/55768882/… — KamilCuk
– KamilCuk, Commented Jun 23, 2021 at 10:16
invalid date ‘"2021-06-23T10:12:00Z"’ You date variable contains 2021-06-23T09:48:00Z or "2021-06-23T09:48:00Z"? Remove the quotes from it. — KamilCuk
– KamilCuk, Commented Jun 23, 2021 at 10:22
Thank you so much for your help. When AWS returns timestamp, it is returned with double quotation marks. </br> So I didn't even have to add or remove the quotes from the date command. </br> I removed these double quotes using the sed command, and replaced them with Unix Timestamp values. </br> Thank you so much. — P.Lonnie
– P.Lonnie, Commented Jun 23, 2021 at 10:29
As of today, both answers here presuppose that you have GNU date (i.e. Linux). The date command on other platforms (MacOS, BSD, AIX, Solaris, etc) lacks the -d option. — tripleee
– tripleee, Commented Aug 15, 2022 at 11:47

Roman Pavelka · Accepted Answer · 2021-06-23 10:15:04Z

3

$ date -d '1970-01-01T00:00:00Z' +"%s"
0

answered Jun 23, 2021 at 10:15

Roman Pavelka

4,2512 gold badges15 silver badges33 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

P.Lonnie · Accepted Answer · 2021-06-23 10:31:51Z

0

I note the direction I solved it.

    timestamp=`echo $value | jq '.Datapoints['$i'].Timestamp'`
    #2021-06-23T09:48:00Z

    timestamp=`echo $timestamp | sed 's/\"//g'`
    echo "[$timestamp]"
    utctimestamp=`date -d $timestamp +%s`

answered Jun 23, 2021 at 10:31

P.Lonnie

1511 gold badge2 silver badges13 bronze badges

Collectives™ on Stack Overflow

Shell script date TZ format to Unix timestamp

2 Answers 2

Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related