Please enable JavaScript.
Coggle requires JavaScript to display documents.
BASIC-SQL-FUNCTIONS - Coggle Diagram
BASIC-SQL-FUNCTIONS
STRING
Length
Upper/Lower
L/R/Trim
Left/Right
Substring
String
Start
[Length]
Locate
SearchString
String
Replace
String
ToReplace
RelaceWith
Concat
NUMERIC
Round
Truncate
Ceiling
Floor
Abs
Rand
Between
0-1
DATE
Now
Curdate/Curtime
Year/Month/Date(Now())
Hour/Minute/Second(Now())
Dayname/Monthname(Now())
Extract(<unit> From Now())
CONDITIONAL
IFNULL
Val1, Val2
Return
Val1 == Null
Val2
Coalesce
First
Return
Non-null
IF
Condition
TrueReturn
FalseReturn
CASE
When
Then
Condition
Value
Multiple
Conditions
Else
End AS Alias
FORMATTING
Date_Format
Time_Format
(DateTimeValue, Format)
CALCULATE
DATE_ADD/SUB
Interval 1 Day
Now()
DATEDIFF
YYYY-MM-DD
Recent, Old
Output
Days
TIME_TO_SEC('09:00')
Since
Midnight