Neoview SQL Reference Manual (R2.5)

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 389)
Returns an integer value in the range 1 through 7 that
represents the corresponding day of the week.
“DAYOFWEEK Function” (page 390)
Returns an integer value in the range 1 through 366 that
represents the corresponding day of the year.
“DAYOFYEAR Function” (page 391)
Returns a specified datetime field from a datetime value
expression or an interval value expression.
“EXTRACT Function” (page 404)
Returns an integer value in the range 0 through 23 that
represents the corresponding hour of the day.
“HOUR Function” (page 406)
Converts a datetime value to a Julian timestamp.“JULIANTIMESTAMP Function” (page 409)
Returns an integer value in the range 0 through 59 that
represents the corresponding minute of the hour.
“MINUTE Function” (page 421)
Returns an integer value in the range 1 through 12 that
represents the corresponding month of the year.
“MONTH Function” (page 423)
Returns a character literal that is the name of the month
of the year (January, February, and so on).
“MONTHNAME Function” (page 424)
Returns an integer value in the range 1 through 4 that
represents the corresponding quarter of the year.
“QUARTER Function” (page 442)
Returns an integer value in the range 0 through 59 that
represents the corresponding second of the minute.
“SECOND Function” (page 463)
Adds the interval of time specified by interval-ind
and num_expr to datetime_expr.
“TIMESTAMPADD Function” (page 477)
Returns the integer value for the number of
interval-ind units of time between startdate and
enddate.
“TIMESTAMPDIFF Function” (page 478)
Returns an integer value in the range 1 through 54 that
represents the corresponding week of the year.
“WEEK Function” (page 487)
Returns an integer value that represents the year.“YEAR Function” (page 488)
See the individual entry for the function.
Mathematical Functions
Use these mathematical functions within an SQL numeric value expression:
Returns the absolute value of a numeric value expression.“ABS Function” (page 344)
Returns the arccosine of a numeric value expression as an
angle expressed in radians.
“ACOS Function” (page 345)
Returns the arcsine of a numeric value expression as an
angle expressed in radians.
“ASIN Function” (page 348)
Returns the arctangent of a numeric value expression as
an angle expressed in radians.
“ATAN Function” (page 349)
Returns the arctangent of the x and y coordinates, specified
by two numeric value expressions, as an angle expressed
in radians.
“ATAN2 Function” (page 350)
Returns the smallest integer greater than or equal to a
numeric value expression.
“CEILING Function” (page 359)
Returns the cosine of a numeric value expression, where
the expression is an angle expressed in radians.
“COS Function” (page 369)
Returns the hyperbolic cosine of a numeric value
expression, where the expression is an angle expressed in
radians.
“COSH Function” (page 370)
340 SQL Functions and Expressions