I want to have some understanding on the below query:
What is the difference between datetime() and timestamp() in Neo4j and for what purpose both these functions are used?
I am using 3.5.3 version installed on Linux.
Yes , It is running 2 different values.
May I know when we can use these functions or for what is the use-case for these functions?
As to usage, this is more up to you and hard to say when one is more appropriate than the other.
If for example you have a UI which prompts a user for a date, and they enter a human readable date, i.e.. 2019-11-12, then maybe you want to record the data in node property as a datetime(). If however they enter the date as 2019-11-12 and you then convert it to a epoch format maybe you want to record the data in a node property as timestamp().
Its really up to you.
Prior to this we only had timestamp() for the ms offset, and had functions in APOC for parsing and formatting based on the ms timestamp.
So as Dana mentioned it is up to you how you want to interact with and manipulate temporal values. APOC still works a bit better for custom parsing and formatting options, but the temporal types and functions are newer and have index support, if you do index a temporal property on a node.
