Advantage SQL Date Issue

[bk171]

Im new to Advantage SQL.  Our CRM system uses it.  Not a fan of it but have to live with it.  Im trying to pull a date out of a datetime field  and im struggling.

 

this is what im using and im getting errors.  Normally in TSQL id use cast/convert or something to accomplish this.

 

select CAST(created as date)
from matrstep

poQuery: Error 7200:  AQE Error:  State = S0000;   NativeError = 2159;  [SAP][Advantage SQL Engine]Invalid argument to scalar function: CAST - unrecognized data type: date. -- Location of error in the SQL statement is: 8

 

[Funce]

This page has a list of data-types valid to advantage SQL

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

Probably looking for SQL_DATE

Edited January 15, 2019 by Funce

[bk171]

Bingo.  That worked.