Neoview SQL Reference Manual (R2.4 SP2)

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 377)
Returns an integer value in the range 1 through 7 that
represents the corresponding day of the week.
“DAYOFWEEK Function” (page 378)
Returns an integer value in the range 1 through 366 that
represents the corresponding day of the year.
“DAYOFYEAR Function” (page 379)
Returns a specified datetime field from a datetime value
expression or an interval value expression.
“EXTRACT Function” (page 392)
Returns an integer value in the range 0 through 23 that
represents the corresponding hour of the day.
“HOUR Function” (page 394)
Converts a datetime value to a Julian timestamp.“JULIANTIMESTAMP Function” (page 397)
Returns an integer value in the range 0 through 59 that
represents the corresponding minute of the hour.
“MINUTE Function” (page 409)
Returns an integer value in the range 1 through 12 that
represents the corresponding month of the year.
“MONTH Function” (page 411)
Returns a character literal that is the name of the month
of the year (January, February, and so on).
“MONTHNAME Function” (page 412)
Returns an integer value in the range 1 through 4 that
represents the corresponding quarter of the year.
“QUARTER Function” (page 430)
Returns an integer value in the range 0 through 59 that
represents the corresponding second of the minute.
“SECOND Function” (page 451)
Adds the interval of time specified by interval-ind
and num_expr to datetime_expr.
“TIMESTAMPADD Function” (page 465)
Returns the integer value for the number of
interval-ind units of time between startdate and
enddate.
“TIMESTAMPDIFF Function” (page 466)
Returns an integer value in the range 1 through 54 that
represents the corresponding week of the year.
“WEEK Function” (page 475)
Returns an integer value that represents the year.“YEAR Function” (page 476)
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 332)
Returns the arccosine of a numeric value expression as an
angle expressed in radians.
“ACOS Function” (page 333)
Returns the arcsine of a numeric value expression as an
angle expressed in radians.
“ASIN Function” (page 336)
Returns the arctangent of a numeric value expression as
an angle expressed in radians.
“ATAN Function” (page 337)
Returns the arctangent of the x and y coordinates, specified
by two numeric value expressions, as an angle expressed
in radians.
“ATAN2 Function” (page 338)
Returns the smallest integer greater than or equal to a
numeric value expression.
“CEILING Function” (page 347)
Returns the cosine of a numeric value expression, where
the expression is an angle expressed in radians.
“COS Function” (page 357)
Returns the hyperbolic cosine of a numeric value
expression, where the expression is an angle expressed in
radians.
“COSH Function” (page 358)
328 SQL Functions and Expressions