The frustration of TO_DATE in SQL
HTML-код
- Опубликовано: 6 сен 2024
- Sick and tired of getting errors or wrong results when dealing with the intricacies of specifying the right date string with the right format mask? Here's the much easier way of specifying dates and timestamps to avoid all the problems.
Follow me!
blog: connor-mcdonal...
twitter: / connor_mc_d
The Podcast!
podcasts.apple...
open.spotify.c...
Subscribe for new tech videos every week
Other social media channels here: linktr.ee/connor
Music: The Wine, The Cars, Ah! Montmartre! - Late Night Feeler
#sql #database
Avoid month names in dates when not in English. Oracle has for some languages changed the binary language definition files between versions previously meaning the format of shortened month names can change between versions to avoid that becoming a problem avoid formats that expect a month name or if needed use the 3rd argument of to date to specify the NLS options for conversion you want. One of the languages affected by this was Hungarian. The facilities to create our own NLB files using NLS workbench was removed in later versions as Oracle stopped including this
Something that would be nice to see is more dates in ISO8601 format.
Doing so avoids month/day ambiguities.
What did he mean by clients ? 🤔
not sure what you're asking