DEV Community

Discussion on: A Case Study of Date and Time

Collapse
 
alexantra profile image
Alex Antra

My fun fact people don't know is that if you do a SELECT DATEDIFF('days', '2001-12-01 23:59:59.999', '2001-12-02 00:00:00.000') it will return 1 day even though the timestamps are different by one millisecond.

Dates in RDS's are tricksey :)