Being a developper on ms-sql databases i Denmark, I hate dates. I have to show the dates on the screen in the format dd:mm:yy. Så the date 12.03.23 is the 12 of march 2023. But its saved in the database as '2023-03-12 09:30:51.500'. (yyyy:mm:dd and the time). And lets not forget the timezones. Is it +1, -1?, or what happens during the daylight saving time. When was data entered with a timestamp 02:30:000? Relatively important in healthcare applications that I am coding. But i haven't got a solution :-)
|