That is not a valid date in CQL, and JSON does not enforce a specific date
format. A correctly formatted date would look something like “2015-01-01
00:00:00”.
From: Ashish Soni
Reply-To: <user@cassandra.apache.org>
Date: Monday, September 28, 2015 at 3:51 PM
To: <user@cassandra.apache.org>
Subject: INSERT JSON TimeStamp
If Anyone can help for below as i am getting the error
effectiveStartDate and effectiveEndDate are TimeStamp
INSERT INTO model.RuleSetSchedule JSON ' {
"ruleSetName": "BOSTONRATES",
"ruleSetId": "829aa84a-4bba-411f-a4fb-38167a987cda",
"scheduleId":1,
"effectiveStartDate": "01/01/2015",
"effectiveEndDate": "12/31/2015",
"rules": {
"1": {
"condition": "BoardStation",
"action": "FareAmount=9.25",
"ruleOrder": "1"
}
}
message="Error decoding JSON value for effectivestartdate: Unable to coerce
'01/01/2015' to a formatted date (long)"
