Тёмный

The frustration of TO_DATE in SQL 

SQL and Database explained!
Подписаться 15 тыс.
Просмотров 1,8 тыс.
50% 1

Опубликовано:

 

21 окт 2024

Поделиться:

Ссылка:

Скачать:

Готовим ссылку...

Добавить в:

Мой плейлист
Посмотреть позже
Комментарии : 4   
@davidmoore4567
@davidmoore4567 Год назад
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
@toomuchtube
@toomuchtube Год назад
Something that would be nice to see is more dates in ISO8601 format. Doing so avoids month/day ambiguities.
@meassurendra
@meassurendra Год назад
What did he mean by clients ? 🤔
@DatabaseDude
@DatabaseDude Год назад
not sure what you're asking
Далее
ASCII and CHR
1:36
Просмотров 1 тыс.
Primary Key options for Partitioned Tables
16:40
Борщ в стиле высокой кухни!
00:57
7 Database Design Mistakes to Avoid (With Solutions)
11:29
Solving one of PostgreSQL's biggest weaknesses.
17:12
Просмотров 205 тыс.
SQL Window Functions in 10 Minutes
10:13
Просмотров 82 тыс.
Improving Readability Through Fewer Arguments
13:12
Просмотров 2,6 тыс.
Learn SQL Basics in Just 15 Minutes!
16:57
Просмотров 162 тыс.
How Wait Events work in the Multi-tenant world
4:46
SQL Joins Explained  |¦| Joins in SQL |¦| SQL Tutorial
10:26
Speeding up Database Constraints
6:59
Просмотров 1,4 тыс.
The BEST way to FETCH from the database
11:58
Просмотров 1,7 тыс.