Microsoft Word - Sam's Teach Yourself MySQL in 21 Days - SAMS.doc

(singke) #1
SELECT SECOND('11:45:01')

Result:

1

SEC_TO_TIME(seconds)


Returns the time in hh:mm:ss format based on the number of seconds given in the argument.
Example:
SELECT SEC_TO_TIME(56789)
Results:


"15:46:29"

SESSION_USER()


Returns the user of the current connection.
Example:
SELECT SESSION_USER()
Result:


'mark@localhost'

SIGN(x)


Returns the sign of x. If x is negative, a –1 is returned. If x is 0, a 0 is returned. If x is positive, a 1 is
returned.
Example:
SELECT SIGN(-14)
Result:


—1
Example:
SELECT SIGN(0)
Result:

0
Example:
SELECT SIGN(45)
Result:

1

SIN(x)


Returns the sine of x where x is in radians
Example:
SELECT SIN(7)
Result: .656987


SOUNDEX(x)


Returns a SOUNDEX string from x.
Example:
SELECT SOUNDEX("George")
Result:


"G620"

SPACE(x)


Returns a string with x number of spaces.
Example:
SELECT SPACE(12)
Result:


" "
Free download pdf