DATE_FORMAT with Edge Cases?!
DATE_FORMAT has HUNDREDS of format codes! %j is day of year, %W is weekday name. This formatting language will confuse you!
#sql #sqltricks #dateformat #formatcodes #dateformatting #sqlweird #sqlquiz #codingchallenge #sqlshorts #sqlwtf #datefunctions #advancedsql
Tired of confusing dates on your Windows 11 taskbar? 🖥️ Learn how to customize short & long date formats, adjust time display, and keep your system organized. Step-by-step guide for personal & professional use!
Found the last #dateformat on a #sophos UTM9 in the logs. Who conceived that log format?! #iso8601 is the only acceptable format for logs.
Fifth the May be with you!! #TimeZone #DateFormat #WarsStar
Die Person wo gmeint hed, MM/DD/YYYY sig es valids Datumsformat, weis me da meh? 😅
Ich mein Tag, Monet, Jahr oder Jahr, Monet, Tag chan ich absolut nachevollzieh. Aber alles andere macht ez würkli kei Sinn…
(OK, ich läb au i dämm Paralleluniversum, wo en Trump US-Präsi wird - zwei Mal!)
🤚 MM/DD/YYYY
🤚 DD/MM/YYYY
🤚 Mmm DD, YYYY
👉 YYYY-MM-DD
Конец года — новые баги с датами
Наткнулся сегодня (24-12-30) на преинтереснейшую ошибку. Простенький скрипт ищет файл по дате создания в имени, и вместо вчерашнего дня (24-12-29) почему-то ищет файл за следующий год (25-12-29). Казалось бы, мистика, всё прекрасно работало с лета, и как на зло сломалось как раз под конец года ... и кто в этом виноват?
https://habr.com/ru/articles/870994/
#java #Date #Format #DateFormat #TimeFormat #yy #happynewyear #сновымгодом
Why do my #MicrosoftOffice and #Excel date formats keep reverting to English US when all my Office and Windows settings say to use English UK? 😠 📅
TBH, #GitHub pisses me off more with their #AmericaCentrism using the #wrong #DateFormat [MMDDYYYY instead of YYYYMMDD or DDMMYYYY] and beginning the week on othe wrong day Sunday instead of Monday and making neither of these configureable for the accounts at all...
@9to5Mac I’m amazed that it even uses the insane m/d/yyyy format. Who in the world of computing doesn’t use yyyy/mm/dd for their logic?
This makes me question the report that this mistake is the reason for the erroneous roll-out.
This just arrived and made me laugh, you know how the old saying goes:
"The first taste is with the sell by date"
Edit Fixed - thank you to
and
#Obsidian #Markdown #DateFormat help please.
I've set my daily notes date format to:
ddd-do-MMM-YYYY
- and today it reads:
Wed-3rd-Mar-2024
Only today is the 6th March, so what should I fix in the date format to accurately reflect today's (aka the current) date?
[ I have already checked and my system clock / date is telling the correct time and date ]
Why doesn't @signalapp for Windows follow the operating system settings for the time format? I thought we were on 2023? 🤔📅
(The Android version certainly seems to know how I want it displayed ...)
#IT #InfoSec #DateFormat #DateFormats #ND #ActuallyAutistic #AuDHD
The only correct date format to use in strings or file names is %Y%m%d because it is the only format that will sort in proper date order. You can put dashes or period in there if you want, as long as you are consistent.
Any other format will sort weird and is, therefore, more trouble than it is worth.
Edit: As many have pointed out, it's even a standard, y'all.
ISO8601
#ISO8601
Edit2: replace ISO page link with Wikipedia because the ISO page requires you to buy a copy if you want to read it.
Unwanted English Keyboards And American Dates
https://therightstuff.medium.com/unwanted-english-keyboards-and-american-dates-3096f58be6d9
I’ve been to the US too often and for far too long. When we returned from out trip there was a letter with in the mailbox with a date for (mandatory) water quality tests. Put it in my calendar for Friday. Well, it was today.
Date in the letter was July 4th and my brain picked it up as 7/4, ignored the send half and thought it would be July 7th. It was today, July 4th.
Hey dear friends in the US, what about making #ISO8601 #dateformat the form. In return you get to keep Fahrenheit. Deal?
reasons to use EDTF - open standard. 8601 is behind a paywall, which is why most people learn about it from vendor docs, not the standard itself. #ISO8601 #DateFormat #OpenStreetMap #OpenHistoricalMap
https://webstore.ansi.org/standards/iso/iso86012019?msclkid=c8821b1afe341ba254557f8a58966e30
Why is the #Philippines #dateformat still "officially" D/M/Y even though EVERYONE outside the military or government documents uses M/D/Y. Not even all government institutions follow D/M/Y.
Well, I use Y/M/D myself but only because I don't find consistency with local "standards."
M/D/Y date formating makes perfect sense for societies where knowing the season is more important than knowing the year.
