Problem while creating time in property

Neo4j Graph Platform
1

Hi,

I am trying to execute following command.

CREATE(AV5076)-[:BANK_TRANSACTION {transaction_amount:2334769,transaction_date:2022-03-17,transaction_time:05:33:53}]->(AS769);

but I am getting following error.
Invalid input '33': expected "%", "(", "NFKD" or an identifier (line 1, column 111 (offset: 110)),

above error is pointing at first colon after hours (after 05) 05:33:53. Here it looks like ":" is creating problem. How can i specify this.

2

Your date and time values either have to be enclosed in quotes, which will store them as strings, or you need to convert them to date and time types.

return 
    date("2022-03-17") as date,
    localtime("05:33:53") as localtime, 
    time("05:33:53-04:00") as EDT
2 Likes
3

Hi Gary,

Thanks a lot it worked. I could able to create dummy data for around 700K nodes and 350k relationship. Once again thanks a ton for prompt help.

REgards,
Rajesh

1 Like