Click here to Skip to main content
15,166,728 members

Welcome to the Lounge

   

For discussing anything related to a software developer's life but is not for programming questions. Got a programming question?

The Lounge is rated Safe For Work. If you're about to post something inappropriate for a shared office environment, then don't post it. No ads, no abuse, and no programming questions. Trolling, (political, climate, religious or whatever) will result in your account being removed.

 
GeneralRe: How did I not know this? Pin
Nelek11-May-21 1:03
protectorNelek11-May-21 1:03 
GeneralRe: How did I not know this? Pin
Sander Rossel10-May-21 22:59
professionalSander Rossel10-May-21 22:59 
GeneralRe: How did I not know this? Pin
Nelek11-May-21 1:02
protectorNelek11-May-21 1:02 
GeneralRe: How did I not know this? Pin
Sander Rossel11-May-21 1:28
professionalSander Rossel11-May-21 1:28 
GeneralRe: How did I not know this? Pin
Nelek11-May-21 1:32
protectorNelek11-May-21 1:32 
GeneralRe: How did I not know this? Pin
Sander Rossel11-May-21 1:34
professionalSander Rossel11-May-21 1:34 
GeneralRe: How did I not know this? Pin
Gerry Schmitz10-May-21 10:26
mveGerry Schmitz10-May-21 10:26 
GeneralRe: How did I not know this? Pin
Mike Winiberg10-May-21 21:27
professionalMike Winiberg10-May-21 21:27 
And yet, and yet....

After all these years, STILL date/time handling is an unimaginable kludge, even amongst systems from one house:

Formatted date/time strings that are acceptable to SQL Server are not acceptable to MS Access JET engine (and vice versa). DATETIME objects may or may not contain the time, depending on how they are generated so you cannot reliably check that they even represent the same day without faffing about.

Despite SQL supposedly being a 'standard', just wait until you try to mix T-SQL, MySQL, PostgresSQL, Oracle etc date handling.

And then there's unix time, MS time, etc...

Back in the early days of C/C++ I used, for many, many years, my own customised version of a Borland Date library because just no-one could handle even the differences between the UK and continental Europe, let alone other countries.

I realise that a lot of these problems are not due to the coding per se - it's the weird way we humans account for and represent time and date across the globe, but you really would think that after all this time, someone, somewhere would have devised a database driven, standardised date/time handling library that could be more or less universally acceptable. We have that for most human languages - just about - after all.
GeneralRe: How did I not know this? Pin
Sander Rossel10-May-21 22:58
professionalSander Rossel10-May-21 22:58 
GeneralRe: How did I not know this? Pin
Choroid11-May-21 7:19
MemberChoroid11-May-21 7:19 
GeneralRe: How did I not know this? Pin
Sander Rossel11-May-21 12:01
professionalSander Rossel11-May-21 12:01 
GeneralRe: How did I not know this? Pin
englebart12-May-21 16:43
professionalenglebart12-May-21 16:43 
GeneralThe Good Life Pin
W Balboos, GHB10-May-21 4:01
mveW Balboos, GHB10-May-21 4:01 
GeneralRe: The Good Life Pin
MarkTJohnson10-May-21 4:04
professionalMarkTJohnson10-May-21 4:04 
JokeRe: The Good Life Pin
Daniel Pfeffer10-May-21 4:58
professionalDaniel Pfeffer10-May-21 4:58 
GeneralRe: The Good Life Pin
Ron Nicholson10-May-21 4:52
professionalRon Nicholson10-May-21 4:52 
GeneralRe: The Good Life Pin
Richard MacCutchan10-May-21 6:12
mveRichard MacCutchan10-May-21 6:12 
GeneralWSO CCC OTD 2021-05-10 Pin
OriginalGriff9-May-21 22:27
mveOriginalGriff9-May-21 22:27 
GeneralRe: WSO CCC OTD 2021-05-10 Pin
pkfox9-May-21 22:49
professionalpkfox9-May-21 22:49 
GeneralRe: WSO CCC OTD 2021-05-10 - we have a winner! Pin
OriginalGriff9-May-21 22:53
mveOriginalGriff9-May-21 22:53 
GeneralRe: WSO CCC OTD 2021-05-10 - we have a winner! Pin
pkfox9-May-21 23:03
professionalpkfox9-May-21 23:03 
GeneralRe: WSO CCC OTD 2021-05-10 - we have a winner! Pin
OriginalGriff9-May-21 23:06
mveOriginalGriff9-May-21 23:06 
GeneralTemplate specializations are the new LISP Pin
honey the codewitch9-May-21 16:03
mvahoney the codewitch9-May-21 16:03 
GeneralRe: Template specializations are the new LISP Pin
11917640 Member 9-May-21 19:32
Member11917640 Member 9-May-21 19:32 
GeneralRe: Template specializations are the new LISP Pin
honey the codewitch9-May-21 19:52
mvahoney the codewitch9-May-21 19:52 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Praise Praise    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.