Google sheet formula to convert a ISO86001 string to a date time:
Input: 2022-06-23T16:31:34.036000+00:00 (cell A2)
Formula: SUM(SPLIT(left(A2,len(A2)-6),"T"))
Output: (a properly-formatted datetime)
# Example command | |
eksctl create iamidentitymapping \ | |
--cluster YOUR_CLUSTER_NAME \ | |
--arn arn:aws:iam::999999999999:role/AWSReservedSSO_YOUR-ROLE_NAME_xxxxxxxxxxxc \ | |
--username cluster-admin \ | |
--group system:masters |
#!/bin/bash | |
# Program: | |
# EC2 initially install node.js, git for development environment. | |
# You can modify nodev and nvmv for changing node and nvm version. | |
# Set permission to ec2-user install above. | |
# History: | |
# 2017/07/25 Hans First release | |
home=/home/ec2-user | |
nodev='8.11.2' | |
nvmv='0.33.11' |
Google sheet formula to convert a ISO86001 string to a date time:
Input: 2022-06-23T16:31:34.036000+00:00 (cell A2)
Formula: SUM(SPLIT(left(A2,len(A2)-6),"T"))
Output: (a properly-formatted datetime)