Sybase Advantage Database Server and DATEPART

Question

I am looking for a query on a Sybase Advantage database server using DATEPART. I get an error message stating the following: "Scalar function not found: datepart". Is there any other function that has similar functions? I am looking to get a date. We are currently running version 9.0.

Answer 1

Of course, I find the answer right after publication ... To search for a quarter, you can use the QUARTER (date) function.

http://devzone.advantagedatabase.com/dz/webhelp/advantage9.0/supported_statements/date_time_functions.htm

Answer 2

You can use QUARTER (date) for what you need.

Read more about here .