swql ToLocal(EventTime) function formatting

Question

In swql, when using the ToLocal to display times local to the database server, I'm using the ToLocal(datevariable) function.

An example of the output is:

Jun 9 2021 1:48PM

Why, why, why, WHY would someone code this to put a space between the date, day and year and somehow fail to put a space in between the minutes and the ante merīdiem / post merīdiem??

Or did I miss something obvious?  Aargh.

Chris-S · Answer

Hey, jm_sysadmin:

How it's displaying now is fine EXCEPT for the missing space between the minutes and the AM/PM.   In your case, the tolocal function isn't showing anti/post meridian at all, it's probably military 24 hour time.  In our region it's most common to use the "short date/time" format shown above in the screenshot, only there's supposed to be a space between the minutes and the AM/PM indication.  It's not a huge deal of course.  I'm looking into using tostring function instead of tolocal now.

jm_sysadmin · Answer

You can access any part of the Date Time that you like, are you just trying to display it differently, or do you need to get at part of the date time and not having the space is a problem. What is the issue that you want solved?

I do see the issue when I take the data and use the ToString function, but not toLocal

Chris-S · Answer

Ok so I checked the IIS server's regional settings.   This is what it looks like:

... that seems to indicate there is a space in the short time format, does it not?   Or is it perhaps the SQL server's regional settings?    This query is being performed by a custom table widget with swql, not ms-sql.  Any ideas?