SQL_SET_DATE_FORMAT¶

Applies to: SQLFlex

This command controls the date format of data returned through embedded SQL. If set to DATAFLEX, then the dates will be returned in whatever format is set in DF_DATE_FORMAT. When set to NATIVE, this command will force dates to return dates in the format specified on the SQL server. Note that in order for the variables to be in the right form, they need to be string variables.

Syntax

SQL_SET_DATE_FORMAT to {DATAFLEX/NATIVE}

Example

SQL_SET_DATE_FORMAT to NATIVE