Bash: Split two strings directly into associative array

I have two strings of same number of substrings divided by a delimiter. I need to create key-value pairs from substrings. Short example: Input: firstString=’00011010:00011101:00100001′ secondString=’H:K:O’ delimiter=’:’ Desired result: ${translateMap[‘00011010’]} -> ‘H’ ${translateMap[‘00011101’]} -> ‘K’ ${translateMap[‘00100001’]} -> ‘O’ So, I wrote: IFS=”$delimiter” read -ra fromArray <<< “$firstString” IFS=”$delimiter” read -ra toArray <<< “$secondString” declare -A…

Details

Trying to Enter DateTime Data into Date Column, Date data is in two different formats

CREATE TABLE Customer_test ( customer_Id BIGINT NOT NULL, DOB DATE NULL DEFAULT ’01-01-1970′, Gender NVARCHAR(250) NULL, city_code NVARCHAR(250) NULL ) INSERT INTO CUSTOMER_test (customer_Id, DOB, Gender, city_code) VALUES (270181, ’01/10/1970′, ‘F’, 2), (268073, ’01/11/1970′, ‘M’, 1), (273216, ’15-01-1970′, ‘F’, 5) I get this error: Conversion failed when converting date and/or time from character string.

Details