This may not be helpful to you, but I've always used the epoch time stored in sq... | Hacker News

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

		module0000 on Feb 12, 2018 \| parent \| context \| favorite \| on: Appropriate Uses for SQLite This may not be helpful to you, but I've always used the epoch time stored in sqlite. It's blazing fast, indexes well(integers !), and is 100% convertible to any format you might need to represent.

hueving on Feb 12, 2018 [–]

Make sure you're using signed integers larger than 32 bits if you ever need dates before ~1970 or after ~2030.

duskwuff on Feb 12, 2018 | [–]

SQLite's INTEGER type is 64 bits, and its REAL type is double-precision (64-bit) floating point. Either type is quite sufficient for representing a time. :)

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