Search code examples
sybaseadvantage-database-serverdatepart

Sybase Advantage Database Server and DATEPART

I'm looking to query a Sybase Advantage Database Server using DATEPART. I get an error message that states the following "Scalar function not found: datepart". Is there another function that has similar functionality? I'm looking get a date's quarter. We are currently running version 9.0.

Solution

  • Of course I find the answer right after posting... For finding the quarter specifically you can use the function QUARTER(date).

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