Sleepless in Seattle!

Not to mention a far more attractive potato than the other candidate's vegetable!

You think anyone else can spell potato better than him? The Donald spells the greatest potato! EVER!

Which is why counting on implicit format mask settings is not recommended! None of those settings matter for anything other than display when you code with explicit conversions where you control the format mask. Otherwise, as you have discovered, you're walking an unknown dependency path waiting for someone else to set the default format for you! Code with TO_DATE(string, mask) and the problem goes away - permenently!

It's not the literals that are the problem - they have their uses. It's assuming that the database will format them the way you want that is the problem. StackOverflow is chock-full-of-examples of people hitting that same problem. Fortunately its an easy thing to not do, and once learned most people are pretty good about remembering. Other than that, lots of perfectly good reasons to hate Oracle. It's been both my nemesis and paycheque for two decades now...lol.

A River Runs Through It. Saddly

Hardly sporting to blame the database because somebody, at some point, made the dumb-assed decision to allow for implicit data conversion - passing a string literal and assuming that nobody would ever change environment settings. Always, always, always, always use an explicit format mask for data conversions from string to date. Did I mention "always"? It's not hard. you don't: WHERE yourDatefield = :your_parameter --fingers crossed and hope it works! Instead: WHERE yourDatefield = TO_DATE(:your_parameter, 'YYYY/MM/DD') -- or whatever your string is formatted as.

Victor Victoria?

Having kids and an ex - spontaneity to that level could lead to an Amber Alert.... That being said, when something interesting comes up I generally try to make it work. Took off with the kids last Friday for a last-minute spring ski weekend. You only get about a week of skiing in above-freezing weather, so you take it - especially when you luck into a discounted hillside condo rental. Took about four hours to get it all put together, packed up, and on the road.

Were this actually true, weekends and vacations would suck....

What's this movie about? Me! I couldn't even get your mother to watch that movie....

Next line: Your skills are now at the point of spiritual insight. Movie: uhhh, Debbie Does Dallas wasn't it? :laugh:

If they call you that whilst they are collectively claiming you for 50% of the time, must we assume that they collectively disown you for the other 50%? :omg:

Currently I have this[^] stretched across my two monitors. It being -24C this morning, it's nice to remember summer!