Update couch db docment date format

Question

Is there way I can update all the date field format existing in documents of couch db

change format from

DateTime : "07-29-2017 19:07:23"

to

DateTime : "2017-07-29 19:07:23"

score 1 · Answer 1 · answered Apr 13 '17 at 03:19

There's no automated way to do this, aside from writing a script that updates each of your documents.

An alternative, depending on your exact situation, might be to use a view to manipulate the data as it's being read. The view could detect the existing date format, and if it's the old one, convert it before displaying the document.

This would change the way you query the data, though--you'd have to request the new view, which could obviously be a deal-breaker in some scenarios.

score 0 · Answer 2 · answered Apr 13 '17 at 03:08

0

First, you need a way to apply a function to every document. To do so, I suggest that you use pouchdb-migrate.

Finally, you only have to define your function and integrate it into pouchdb-migrate. You can either parse the date and convert it or simply do some string manipulation.

answered Apr 13 '17 at 03:08

Alexis Côté

3,670
2
14
30

The question is about couchdb, not pouchdb. – Jonathan Hall Apr 13 '17 at 03:17
I know but that's a possible solution. You can use some script in JavaScript to solve your problem. You can implement this language in any other language... – Alexis Côté Apr 14 '17 at 13:37

Update couch db docment date format

2 Answers2