Using SQL to convert date to words

  Рет қаралды 80

AS400 and SQL Tricks

AS400 and SQL Tricks

Ай бұрын

#ibmi #as400 #sql
Using SQL to convert date to words
SELECT
dayname(current date) concat ',' concat
Dayofmonth(current date) concat ' ' concat
monthname(current date) concat ' ' concat
year(current date)
fROM sysibm.sysdummy1
CURRENT DATE
05/27/24
Date in words
Monday,27 May 2024

Пікірлер
Using SQL to search History log
7:14
Using SQL to search History log
AS400 and SQL Tricks
Рет қаралды 72
I love my database GUI
9:27
I love my database GUI
PlanetScale
Рет қаралды 58 М.
Always be more smart #shorts
00:32
Always be more smart #shorts
Jin and Hattie
Рет қаралды 36 МЛН
Luck Decides My Future Again 🍀🍀🍀 #katebrush #shorts
00:19
Luck Decides My Future Again 🍀🍀🍀 #katebrush #shorts
Kate Brush
Рет қаралды 8 МЛН
Please be kind🙏
00:34
Please be kind🙏
ISSEI / いっせい
Рет қаралды 180 МЛН
The child was abused by the clown#Short #Officer Rabbit #angel
00:55
The child was abused by the clown#Short #Officer Rabbit #angel
兔子警官
Рет қаралды 15 МЛН
SQL Tutorial #29 - Date and Time Functions in SQL
6:46
SQL Tutorial #29 - Date and Time Functions in SQL
Software Testing Mentor
Рет қаралды 39 М.
sql query for 2nd highest salary
3:37
sql query for 2nd highest salary
As400
Рет қаралды 43
Open Query File (OPNQRYF)- Using *GT operator on selection
8:33
Open Query File (OPNQRYF)- Using *GT operator on selection
AS400 and SQL Tricks
Рет қаралды 15
Bill Gates Reveals Superhuman AI Prediction
57:18
Bill Gates Reveals Superhuman AI Prediction
Next Big Idea Club
Рет қаралды 1,2 М.
Access 2016 - How to Make a Database - Part 1 - Tables
15:53
Access 2016 - How to Make a Database - Part 1 - Tables
Design and Deploy
Рет қаралды 1,5 МЛН
Stop Wasting Time on the Wrong Languages
2:15
Stop Wasting Time on the Wrong Languages
Programming with Mosh
Рет қаралды 54 М.
Databricks Certified Data Engineer Associate Exam Questions Dumps SEP-OCT 2023 (45 Real Questions)
59:21
Databricks Certified Data Engineer Associate Exam Questions Dumps SEP-OCT 2023 (45 Real Questions)
sthithapragna
Рет қаралды 24 М.
Temp Tables in MySQL | Advanced MySQL Series
7:46
Temp Tables in MySQL | Advanced MySQL Series
Alex The Analyst
Рет қаралды 18 М.
Always be more smart #shorts
00:32
Always be more smart #shorts
Jin and Hattie
Рет қаралды 36 МЛН