Re:Unstructured Datatypes in Postgres – Hstore vs. JSON vs. ...
by darklajid on Thursday July 21, 2016 @10:34AM
(#12137096)
I mentioned the limitation ("no datetime in json") in my post :-)
That said, you and IanCal have a point: I could just drop the idea of DateTimes and use timestamps/integers - converting queries in my application.
With either approach you'll have to do some mapping in and out of the system (though date probably serialises to string more or less out of the box for most json libs).
[1] http://stackoverflow.com/questions/10286204/the-right-json-d...