Odd date/time formatting

VoucherMan

Mrs_Salad_Dodger said:

Any update? 

I guess not since I've come looking 3 days after your comment.

It does appear limited to posts made on the day they're being viewed (today's posts) only, as far as I can tell, and the post time is still visible on the link, so maybe they've decided it's a low priority. (or more likely, not a priority)

PHK

It does seem odd that something as basic as date and time can be so wrong. 

MollyR

Now showing in the format 14 February am28 10:38AM.

MTA:  Well, it was - and now it's back to UTC202520pm25 pm28 4:35PM!

MSE_James

The format depends on whether you're looking at a post from today or a previous day, with posts from the current day having the most mangled date format.

Thank you to everyone for their patience whilst our software provider investigates the issue. 

Bridlington1

MSE_James said:

The format depends on whether you're looking at a post from today or a previous day, with posts from the current day having the most mangled date format.

Thank you to everyone for their patience whilst our software provider investigates the issue. 

With the caveat that if you hover over the date/time of a post from today it appears in the same format as posts from the previous day.



I appreciate the update though.

jimjames

MSE_James said:

Our forum software provider released a software update yesterday - rest assured we'll be liaising with them to get things back to normal

7 days on it's still not fixed

Eco_Miser

PHK said:

It does seem odd that something as basic as date and time can be so wrong. 

It's not so wrong, just horribly mangled.

Dates and times are stored as number of days (and fraction of a day) since a certain moment (eg 00:00 1st January 1900) and converted for display by a standard library routine which takes as input the datetime value and a format string. The format string uses simple codes to specify which part of the date to display, such as the timezone (UTC) year (2025) day (20) am/pm(pm) 2digit year(25) am/pm(pm) days-in-month(28) hours:minutesam/pm (4:35PM) to dissect an example given earlier. Months can be full name, short name (Feb), or number (with or without a leading zero), years can have 2 or 4 digits, times can be 12 hour or 24 hour, etc. Quite complicated.

It's strange that it's taken over a week to dig into the changes made recently and find the typo'd format string.

Neil_Jones

Eco_Miser said:

PHK said:

It does seem odd that something as basic as date and time can be so wrong. 

It's not so wrong, just horribly mangled.

Dates and times are stored as number of days (and fraction of a day) since a certain moment (eg 00:00 1st January 1900) and converted for display by a standard library routine which takes as input the datetime value and a format string.

Its almost certainly Unix based and therefore it will be the number of seconds since January 1 1970.

Eco_Miser

Thank you, I just couldn't remember that at the time. 00:00 1st January 1900 is the base for Libre Office spreadsheets.

VoucherMan

Eco_Miser said:

It's strange that it's taken over a week to dig into the changes made recently and find the typo'd format string.

Quite complicated.

Should be quite simple for any half decent coder.

Maybe we should suggest to the MSE team that the forum could be improved with a volunteer takeover. At least they could save money on this botch up. IMO, it's never worked well since they ditched vBulletin.