4 ms·
what are the data type problems?
by ddorian43 13y ago
what are the data type problems?
- jzwinck 13y agoWell, some of us have been asking for a native high-resolution time type for three years: https://jira.mongodb.org/browse/SERVER-1460 https://jira.mongodb.org/browse/SERVER-1460
- rudiger 13y agoCan't you just store it in a regular 64-bit integer and know it's a datetime from your application's logic? What do you gain with a native, high-resolution datatime type?
- bqe 13y agoAutomatic timezone conversion and the ability to add and subtract dates without first dropping to your 64-bit into. Think DATE_SUB(date time, INTERVAL 1 HOUR) from MySQL for instance.
- rpedela 13y agoSupport for arbitrary-precision decimal. Known as numeric/decimal in Postgres. This can be a problem for financial and scientific applications.
- spongle 13y agoYep we canned it because of that, plus it was unreliable and our code and architectural review scared the shit out of us.