Neoview SQL Reference Manual (R2.4)

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 368)
Returns an integer value in the range 1 through 7 that
represents the corresponding day of the week.
“DAYOFWEEK Function” (page 369)
Returns an integer value in the range 1 through 366 that
represents the corresponding day of the year.
“DAYOFYEAR Function” (page 370)
Returns a specified datetime field from a datetime value
expression or an interval value expression.
“EXTRACT Function” (page 383)
Returns an integer value in the range 0 through 23 that
represents the corresponding hour of the day.
“HOUR Function” (page 385)
Converts a datetime value to a Julian timestamp.“JULIANTIMESTAMP Function” (page 388)
Returns an integer value in the range 0 through 59 that
represents the corresponding minute of the hour.
“MINUTE Function” (page 404)
Returns an integer value in the range 1 through 12 that
represents the corresponding month of the year.
“MONTH Function” (page 406)
Returns a character literal that is the name of the month
of the year (January, February, and so on).
“MONTHNAME Function” (page 407)
Returns an integer value in the range 1 through 4 that
represents the corresponding quarter of the year.
“QUARTER Function” (page 425)
Returns an integer value in the range 0 through 59 that
represents the corresponding second of the minute.
“SECOND Function” (page 446)
Adds the interval of time specified by interval-ind
and num_expr to datetime_expr.
“TIMESTAMPADD Function” (page 460)
Returns the integer value for the number of
interval-ind units of time between startdate and
enddate.
“TIMESTAMPDIFF Function” (page 461)
Returns an integer value in the range 1 through 54 that
represents the corresponding week of the year.
“WEEK Function” (page 477)
Returns an integer value that represents the year.“YEAR Function” (page 478)
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 324)
Returns the arccosine of a numeric value expression as an
angle expressed in radians.
“ACOS Function” (page 325)
Returns the arcsine of a numeric value expression as an
angle expressed in radians.
“ASIN Function” (page 328)
Returns the arctangent of a numeric value expression as
an angle expressed in radians.
“ATAN Function” (page 329)
Returns the arctangent of the x and y coordinates, specified
by two numeric value expressions, as an angle expressed
in radians.
“ATAN2 Function” (page 330)
Returns the smallest integer greater than or equal to a
numeric value expression.
“CEILING Function” (page 339)
Returns the cosine of a numeric value expression, where
the expression is an angle expressed in radians.
“COS Function” (page 348)
Returns the hyperbolic cosine of a numeric value
expression, where the expression is an angle expressed in
radians.
“COSH Function” (page 349)
320 SQL Functions and Expressions