Neoview SQL Reference Manual (R2.3)

Translates a character string from a source character set
to a target character set.
“TRANSLATE Function” (page 428)
Removes leading or trailing characters from a character
string.
“TRIM Function” (page 429)
Upshifts single-byte characters. You can also use UPSHIFT
or UPPER.
“UCASE Function” (page 430)
Upshifts single-byte characters. You can also use UPSHIFT
or UCASE.
“UPPER Function” (page 438)
Upshifts single-byte characters. You can also use UPPER
or UCASE.
“UPSHIFT Function” (page 439)
See the individual entry for the function.
Datetime Functions
These functions use either a datetime value expression as an argument or return a result of
datetime data type:
Adds the integer number of months specified by
intr_expr to datetime_expr and normalizes the
result.
“ADD_MONTHS Function” (page 298)
Converts a Julian timestamp to a TIMESTAMP value.“CONVERTTIMESTAMP Function” (page 318)
Returns the current timestamp. You can also use the
“CURRENT_TIMESTAMP Function”.
“CURRENT Function” (page 323)
Returns the current date.“CURRENT_DATE Function” (page 324)
Returns the current time.“CURRENT_TIME Function” (page 326)
Returns the current timestamp. You can also use the
“CURRENT Function”.
“CURRENT_TIMESTAMP Function” (page 327)
Adds the interval specified by interval_expression
to datetime_expr.
“DATE_ADD Function” (page 329)
Subtracts the specified interval_expression from
datetime_expr.
“DATE_SUB Function” (page 330)
Extracts the datetime field specified by text from the
interval value specified by interval and returns the
result as an exact numeric value.
“DATE_PART Function (of an interval)” (page 333)
Extracts the datetime field specified by text from the
datetime value specified by timestamp and returns the
result as an exact numeric value.
“DATE_PART Function (of a timestamp)” (page 334)
Returns the date with the time portion of the day
truncated.
“DATE_TRUNC Function” (page 335)
Adds the interval specified by datepart and num_expr
to datetime_expr.
“DATEADD Function” (page 330)
Returns the integer value for the number of datepart
units of time between startdate and enddate.
“DATEDIFF Function” (page 332)
Formats a datetime value for display purposes.“DATEFORMAT Function” (page 333)
Returns an integer value in the range 1 through 31 that
represents the corresponding day of the month. You can
also use DAYOFMONTH.
“DAY Function” (page 336)
Returns the name of the day of the week from a date or
timestamp expression.
“DAYNAME Function” (page 337)
Returns an integer value in the range 1 through 31 that
represents the corresponding day of the month. You can
also use DAY.
“DAYOFMONTH Function” (page 338)
Categories 291