wrap values with free text mysql json_object

Asked Dec 27 '18 at 16:05

Active Dec 27 '18 at 19:11

Viewed 55 times

I have this script that works well:

SELECT json_object(
  ...
  'lastEdited', DATE_FORMAT(NOW(), '%Y-%m-%dT%TZ')
)

and it prints out:

"lastEdited": "2018-12-27T18:02:48Z",

but I would like it to be:

"lastEdited": ISODate("2018-12-27T18:02:48Z"),

is it possible to wrap it with ISODate()?

edited Dec 27 '18 at 19:11

Daniel E.

asked Dec 27 '18 at 16:05

JohnBigs

@DanielE.yes, im writing script that reads from mysql and gives me jsons that i can insert to mongo – JohnBigs Dec 27 '18 at 16:13
https://stackoverflow.com/questions/11486779/formatting-isodate-from-mongodb – Daniel E. Dec 27 '18 at 16:22

0 Answers0