![]() |
SQL-J Language Reference
|
Reference Manual |
EXTRACTEXTRACT extracts the specified field from a date/time expression as an integer or double-precision value. SyntaxEXTRACT (Field FROM DateTimeExpression) The fields available for extraction depend on the date/time type that EXTRACT is applied to, as listed in Table 1-5, "Extractable Fields in Date/Time Data Types"
The result type of EXTRACT is INTEGER except when extracting SECOND from a TIMESTAMP. In the current release, the result type of extracting SECOND from a TIMESTAMP is DOUBLE PRECISION. The result type of extracting SECOND from a TIME is an INT. EXTRACT Example |
||||||||||||||||||||||||||||
|
![]() Cloudscape Version 3.6 For information about Cloudscape technical support, go to: www.cloudscape.com/support/.Copyright © 1998, 1999, 2000 Informix Software, Inc. All rights reserved. |