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

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:

" "