Chapter 8 SQL Functions
363
SELECT ROUND( 123.234, 1 )
♦ SQL/92 Vendor extension.
♦
Sybase Compatible with Adaptive Server Enterprise.
"TRUNCNUM function" on page 373
RTRIM function [String]
Returns a string with trailing blanks removed.
RTRIM (
string-expression
)
string-expression The string to be trimmed.
The following statement returns the string Test Message, with all trailing
blanks removed.
SELECT RTRIM( ’Test Message ’ )
♦ SQL/92 Vendor extension.
♦
Sybase Compatible with Adaptive Server Enterprise.
"LTRIM function" on page 347
SECOND function [Date and time]
Returns a number from 0 to 59 corresponding to the second component of
the given datetime value.
SECOND (
datetime-expression
)
datetime-expression The datetime value.
The following statement returns the value 21.
SELECT SECOND( ’1998-07-13:21:21:25’ )
♦ SQL/92 Vendor extension.
♦
Sybase Compatible with Adaptive Server Enterprise.
SECONDS function [Date and time]
Returns the number of seconds since an arbitrary date and time, between two
times, or adds an integer amount of seconds to a time.
Standards and
compatibility
See also
Function
Syntax
Parameters
Examples
Standards and
compatibility
See also
Function
Syntax
Parameters
Examples
Standards and
compatibility
Function
To Next Page
Loading...