• 1 Post
  • 5 Comments
Joined 2 years ago
cake
Cake day: June 11th, 2023

help-circle
  • On AniDB I can enter dd.MM.yyyy or yyyy-MM-dd (text input), which I like a lot. I often prefer reading and writing yyyy-MM-dd.

    Some time ago I changed my Windows number format settings to show me yyyy-MM-dd formats. Unfortunately, that broke my webbrowsers date input / datepicker. :( So I had to go back to the standard culture format (de in my case).

    The worst is when you work with dates and don’t know what is what, or when the behavior is unexpected.

    Probably everyone knows about the Excel shitshow of implicitly converted values.

    In SQL Server, what do you think 0000-00-00 is when converted to a date, explicitly or implicitly? Well, unfortunately, yyyyMMdd is a safer format than yyyy-MM-dd.

    SET LANGUAGE 'us_english'
    SELECT CONVERT(date, '2025-12-13')
    --SELECT CONVERT(date, '2025-13-12') -- err
    SELECT CONVERT(datetime, '2025-12-13 07:00:00')
    --SELECT CONVERT(datetime, '2025-13-12 07:00:00') -- err
    
    SET LANGUAGE 'Deutsch'
    SELECT CONVERT(date, '2025-12-13')
    --SELECT CONVERT(date, '2025-13-12') --err
    --SELECT CONVERT(datetime, '2025-12-13 07:00:00') --err !!
    SELECT CONVERT(datetime, '2025-13-12 07:00:00')
    

    No, yyyy-dd-MM is not a common or valid German date format. That’s usually dd.MM.yyyy.



  • Your question was very unspecific and broad, and despite that, now it goes into a direction I have not foreseen. Your question would have been much more useful and you would have received a lot better answers if you had provided some context, established a premise, been more specific about what you’re asking.

    You asked about PC. Given that Windows is the prevalent PC operating system, I’ll answer for that.

    While Windows has a Microsoft Store app store now, traditionally and still prevalent, most software and applications is installed and managed not through this “app store”, but manually or with other non-OS-integrated software.

    I feel like the premise of the question is from a very different understanding of how things work or are.


  • Microsoft pushes cloud and AI with increasingly negative side-effects. Eventually, EU regulation steps in to require offline-capable OS with fair and obvious choice. Microsoft tries to argue security, but ultimately fails.

    Microsoft continues to push and connect their services as one, with synergy effects. Eventually EU regulation and prosecution steps in, requiring a neutral OS that must not pre-install software or point to other products in OS settings and apps, etc. Integrations must be openly standardized first, before implementing their own.

    Despite all this, and despite a move from EU and EU-national institutions to sovereignty through shared open source solutions, Microsoft retains their strong/prevalent market position because the market as a whole is not as strategic and concerned, and Microsoft products like office, onedrive, Teams, and their other business software and services remain a predominant and grab-first choice, and the security promise of big enterprise software, battle-tested, with strong established auth etc remains a big selling point for them.