4D v13.4

EXTRACT

Home

 
4D v13.4
4D SQL Reference
Functions
EXTRACT

EXTRACT  


 

 

Command EXTRACTEXTRACT ({YEAR | MONTH | DAY | HOUR | MINUTE | SECOND | MILLISECOND} FROM arithmetic_expression)

The EXTRACT function returns the specified part which it extracts from the arithmetic_expression. The arithmetic_expression passed should be of the Timestamp type.

Example  

This example returns all the invoice numbers from the month of January:

SELECT INVOICE_NO
FROM INVOICES
WHERE EXTRACT(MONTH(INVOICE_DATE)) = 1;

 
PROPERTIES 

Product: 4D
Theme: Functions

 
INDEX

Alphabetical list of commands