Please enable JavaScript.
Coggle requires JavaScript to display documents.
Data Types (Formatting Dates (DAY() (SELECT DAY(column) FROM table),…
Data Types
Formatting Dates
-
-
-
-
DATEFORMAT(date, format)
SELECT DATEFORMAT('2017-10-21', '%W-%M-%Y')
-
-
-
-
-
char
char(6)
data less than 6 characters, spaces will be added
-
varchar
varchar(6)
Data less than 6 characters, no spaces will be added.
Data more than 6 characters, will be truncated