Is there a simple way to get a date only from Json Date

SQL++
1

I have queries that return a lot of dates which are in a JSON date format . Is there a simple format that will just return a short or long date format or do i have to string this together based one the Date Function since
select date_format_str("2016-09-23T18:48:11Date.000+00:00", "1234-12-12" )
does only return 2016-09-23 but no way to return 09/23/2016 or 23/09/2016 etc also no easy way to get date and time together or consider date locality format like usa has mm/dd/yyyY vs europe has dd/mm/yyyy

2

There is no DateTime data type in JSON. ISO-8601 format stored as string is string comparable .
N1QL supports ISO-8601 format or MILLIS. You can use https://docs.couchbase.com/server/current/n1ql/n1ql-language-reference/datefun.html date functions or SUBSTR(“2016-09-23T18:48:11”,0,10)

3

JSON does not know anything about dates. What .NET does is a non-standard hack/extension. The problem with dates in JSON and really JavaScript in general – is that there’s no equivalent literal representation for dates. In JavaScript following Date constructor straight away converts the milliseconds since 1970 to Date as follows:

var jsonDate = new Date(1297246301973);

Then let’s convert it to js format:

var date = new Date(parseInt(jsonDate.substr(6)));

The substr() function takes out the /Date( part, and the parseInt() function gets the integer and ignores the )/ at the end. The resulting number is passed into the Date constructor .