Can't you just store it in a regular 64-bit integer and know it's a datetime fro... | Hacker News

Hacker Newsnew | past | comments | ask | show | jobs | submit

		rudiger on Oct 4, 2013 \| parent \| context \| favorite \| on: MongoDB Raises $150 Million at $1.2 Billion Valuat... Can'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 on Oct 4, 2013 [–]

Automatic 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.

Guidelines | FAQ | Lists | API | Security | Legal | Apply to YC | Contact