Neoview SQL Reference Manual (R2.3)

Returns an integer value in the range 1 through 7 that
represents the corresponding day of the week.
“DAYOFWEEK Function” (page 339)
Returns an integer value in the range 1 through 366 that
represents the corresponding day of the year.
“DAYOFYEAR Function” (page 340)
Returns a specified datetime field from a datetime value
expression or an interval value expression.
“EXTRACT Function” (page 353)
Returns an integer value in the range 0 through 23 that
represents the corresponding hour of the day.
“HOUR Function” (page 355)
Converts a datetime value to a Julian timestamp.“JULIANTIMESTAMP Function” (page 358)
Returns an integer value in the range 0 through 59 that
represents the corresponding minute of the hour.
“MINUTE Function” (page 374)
Returns an integer value in the range 1 through 12 that
represents the corresponding month of the year.
“MONTH Function” (page 376)
Returns a character literal that is the name of the month
of the year (January, February, and so on).
“MONTHNAME Function” (page 377)
Returns an integer value in the range 1 through 4 that
represents the corresponding quarter of the year.
“QUARTER Function” (page 396)
Returns an integer value in the range 0 through 59 that
represents the corresponding second of the minute.
“SECOND Function” (page 414)
Returns an integer value in the range 1 through 54 that
represents the corresponding week of the year.
“WEEK Function” (page 443)
Returns an integer value that represents the year.“YEAR Function” (page 444)
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 296)
Returns the arccosine of a numeric value expression as an
angle expressed in radians.
“ACOS Function” (page 297)
Returns the arcsine of a numeric value expression as an
angle expressed in radians.
“ASIN Function” (page 300)
Returns the arctangent of a numeric value expression as
an angle expressed in radians.
“ATAN Function” (page 301)
Returns the arctangent of the x and y coordinates, specified
by two numeric value expressions, as an angle expressed
in radians.
“ATAN2 Function” (page 302)
Returns the smallest integer greater than or equal to a
numeric value expression.
“CEILING Function” (page 311)
Returns the cosine of a numeric value expression, where
the expression is an angle expressed in radians.
“COS Function” (page 319)
Returns the hyperbolic cosine of a numeric value
expression, where the expression is an angle expressed in
radians.
“COSH Function” (page 320)
Converts a numeric value expression expressed in radians
to the number of degrees.
“DEGREES Function” (page 344)
Returns the exponential value (to the base e) of a numeric
value expression.
“EXP Function” (page 349)
Returns the largest integer less than or equal to a numeric
value expression.
“FLOOR Function” (page 354)
292 SQL Functions and Expressions