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

It's not elegant at all. This is a horrible idea because it doesn't account for time zone transitions. You could even end up with a time that will never appear on your clock.

For example, what is the answer to in New York?

    SELECT DATETIME('2025-03-07 23:30:00', '+1 day', '+3 hours');
If you said `2025-03-09 02:30:00`, then that would just be wrong. Because that time never appeared on clocks in New York.


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

Search: