sql Flashcards
1
Q
turning str uppercase
A
Ucase()/Upper()
2
Q
length of a str
A
Length()
3
Q
concatenates/joins multiple str
A
concat()
4
Q
removes extra spaces from right/left/both
A
ltrim(),rtrim(),trim()
5
Q
extracts certain no of char from any part of string
A
substr()/mid()
6
Q
searches for one str inside another and returns position
A
instr()
7
Q
extracts char from left/right
A
left()/right()
8
Q
extracts parts of date
A
month(), year()
9
Q
extracts date from date and time
A
date()
10
Q
What does Dayname() return?
A
It returns the name of the weekday.
11
Q
What does Now() return?
A
It returns the current date and time.
12
Q
What does MONTHNAME() return?
A
It returns the name of the month for a given date.
13
Q
What does DAY() return?
A
It returns an integer value which represents the day of a month (1-31) of a specified date.
