View Single Post
Old 02-01-2023, 03:38 AM   #1332
fum
Zealot
fum ought to be getting tired of karma fortunes by now.fum ought to be getting tired of karma fortunes by now.fum ought to be getting tired of karma fortunes by now.fum ought to be getting tired of karma fortunes by now.fum ought to be getting tired of karma fortunes by now.fum ought to be getting tired of karma fortunes by now.fum ought to be getting tired of karma fortunes by now.fum ought to be getting tired of karma fortunes by now.fum ought to be getting tired of karma fortunes by now.fum ought to be getting tired of karma fortunes by now.fum ought to be getting tired of karma fortunes by now.
 
Posts: 120
Karma: 728454
Join Date: Aug 2009
Location: Århus, Denmark
Device: PWII
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 :-)
fum is offline   Reply With Quote