Thanks a Lot , Also i have single quote in JSON but CQL Doesnt Like it even
when i escape it
* "condition": "BoardStation =='Lowell' ",*
*i tried *
* "condition": "BoardStation ==\'Lowell\' ",*
INSERT INTO model.RuleSetSchedule JSON ' {
"ruleSetName": "BOSTONRATES",
"ruleSetId": "829aa84b-4bba-411f-a4fb-38167a987cda",
"scheduleId":1,
"effectiveStartDate": "2015-02-01 00:00:00",
"effectiveEndDate": "2015-03-01 00:00:00",
"rules": {
"1": {
* "condition": "BoardStation =='Lowell' ",*
"action": "FareAmount=9.25",
"ruleOrder": "1"
}
}
}';
On Mon, Sep 28, 2015 at 4:11 PM, Steve Robenalt <[email protected]>
wrote:
> Hi Ashish,
>
> Most Json parsers expect either a raw long integer value or some version
> of an iso-8601 date or timestamp.
>
> See https://en.wikipedia.org/wiki/ISO_8601 for a good reference.
>
> Steve
>
>
> On Mon, Sep 28, 2015 at 1:08 PM, Russell Bradberry <[email protected]>
> wrote:
>
>> 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: <[email protected]>
>> Date: Monday, September 28, 2015 at 3:51 PM
>> To: <[email protected]>
>> 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)"
>>
>
>
>
> --
> Steve Robenalt
> Software Architect
> [email protected] <[email protected]>
> (office/cell): 916-505-1785
>
> HighWire Press, Inc.
> 425 Broadway St, Redwood City, CA 94063
> www.highwire.org
>
> Technology for Scholarly Communication
>
