SQL Commands: Difference between revisions
Jump to navigation
Jump to search
No edit summary |
No edit summary |
||
| Line 1: | Line 1: | ||
== SQLite 3 | = Functions = | ||
{| class="wikitable" | |||
! || Postgres || MariaDB || SQLite | |||
|- | |||
| List tables | |||
| <syntaxhighlight lang="sql"></syntaxhighlight> | |||
| <syntaxhighlight lang="sql"></syntaxhighlight> | |||
| <syntaxhighlight lang="sql"></syntaxhighlight> | |||
|} | |||
= Visiting = | |||
= SQLite 3 = | |||
{| class="wikitable" | {| class="wikitable" | ||
! TODO || Command | ! TODO || Command | ||
Revision as of 07:34, 8 April 2025
Functions
| Postgres | MariaDB | SQLite | |
|---|---|---|---|
| List tables |
Visiting
SQLite 3
| TODO | Command |
|---|---|
| yyyymmdd to yyyy-mm-dd |
SELECT printf('%s-%s-%s',
SUBSTR(trading_date,1,4),
SUBSTR(trading_date,5,2),
SUBSTR(trading_date,7,2)
) FROM short_sell WHERE trading_date='20190605';
|