Is there an equivalent of extract method of MySQL in Apache Derby?

Question

Is there an equivalent of extract method of MySQL in Apache Derby? Or doesn't Derby support it?

Answer 1

Derby does not have an exact equivalent of extract.

It has:

• Second
• Minute
• Hour
• Day
• Month
• Year

But you can always write your own functions:

CREATE FUNCTION TO_DEGREES(RADIANS DOUBLE) RETURNS DOUBLE
PARAMETER STYLE JAVA NO SQL LANGUAGE JAVA
EXTERNAL NAME 'java.lang.Math.toDegrees'

See also:

• Overview: https://wiki.apache.org/db-derby/DerbySQLroutines
• DayOfWeekExample: https://mail-archives.apache.org/mod_mbox/db-derby-user/200510.mbox/%[email protected]%3E