DATEPART

DATEPART takes two arguments: a control string and a timestamp. It returns the part of the timestamp specified by the control string:

Integer DATEPART( control Varchar, value Timestamp )

Example

The following code:

SELECT ORDERS.ORDERID, ORDERS.SHIPBYDATE

FROM "../Data Sources/MyDatabase/ORDERS.SMA" ORDERS

WHERE DATEPART('m', ORDERS.SHIPBYDATE) = 5

returns:

1645,1995-05-22 00:00:00.0

1725,1995-05-10 00:00:00.0

1125,1995-05-03 00:00:00.0

…

Copyright Actuate Corporation 2012