Neoview SQL Reference Manual (R2.2)

Returns an integer value in the range 1 through 366 that
represents the corresponding day of the year.
“DAYOFYEAR Function” (page 329)
Returns a specified datetime field from a datetime value
expression or an interval value expression.
“EXTRACT Function” (page 342)
Returns an integer value in the range 0 through 23 that
represents the corresponding hour of the day.
“HOUR Function” (page 344)
Converts a datetime value to a Julian timestamp.“JULIANTIMESTAMP Function” (page 347)
Returns an integer value in the range 0 through 59 that
represents the corresponding minute of the hour.
“MINUTE Function” (page 363)
Returns an integer value in the range 1 through 12 that
represents the corresponding month of the year.
“MONTH Function” (page 365)
Returns a character literal that is the name of the month
of the year (January, February, and so on).
“MONTHNAME Function” (page 366)
Returns an integer value in the range 1 through 4 that
represents the corresponding quarter of the year.
“QUARTER Function” (page 385)
Returns an integer value in the range 0 through 59 that
represents the corresponding second of the minute.
“SECOND Function” (page 403)
Returns an integer value in the range 1 through 54 that
represents the corresponding week of the year.
“WEEK Function” (page 432)
Returns an integer value that represents the year.“YEAR Function” (page 433)
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 286)
Returns the arccosine of a numeric value expression as an
angle expressed in radians.
“ACOS Function” (page 287)
Returns the arcsine of a numeric value expression as an
angle expressed in radians.
“ASIN Function” (page 290)
Returns the arctangent of a numeric value expression as
an angle expressed in radians.
“ATAN Function” (page 291)
Returns the arctangent of the x and y coordinates, specified
by two numeric value expressions, as an angle expressed
in radians.
“ATAN2 Function” (page 292)
Returns the smallest integer greater than or equal to a
numeric value expression.
“CEILING Function” (page 300)
Returns the cosine of a numeric value expression, where
the expression is an angle expressed in radians.
“COS Function” (page 308)
Returns the hyperbolic cosine of a numeric value
expression, where the expression is an angle expressed in
radians.
“COSH Function” (page 309)
Converts a numeric value expression expressed in radians
to the number of degrees.
“DEGREES Function” (page 333)
Returns the exponential value (to the base e) of a numeric
value expression.
“EXP Function” (page 338)
Returns the largest integer less than or equal to a numeric
value expression.
“FLOOR Function” (page 343)
Returns the natural logarithm of a numeric value
expression.
“LOG Function” (page 352)
282 SQL Functions and Expressions