DFDateToSQLDate - cSQLStatement

Converts a DataFlex Date data type to a SQL date value that can be used with embedded SQL

Type: Function
Return Data Type: String

Parameters

Parameter	Type	Description
dDFDate	Date	DataFlex date
iSQLType	Integer	(Optional) Native SQL data type, can be SQL_TYPE_TIMESTAMP or SQL_TYPE_DATE, SQL_TYPE_TIMESTAMP if not passed

Syntax

Function DFDateToSQLDate Date dDFDate Integer iSQLType Returns String

Call Example

Get DFDateToSQLDate dDFDate iSQLType to StringVariable

Description

This function will convert a DataFlex date value to a SQL date value that can be used with embedded SQL.

This function can be used to pass date type parameters to a stored procedure, for example.

Sample

Sysdate dToday
Send SQLSetProcedureName of hStmt "spTodaysOrders"
Get DFDateToSQLDate of hStmt dToday to sToday
Send SQLSetArgument of hStmt 1 to sToday

If the passed DataFlex date is 0, the returned SQL date will be the dummy zero date (1753-01-01 for SQL_TYPE_TIMESTAMP, 0001-01-01 for SQL_TYPE_DATE).

String sSQLDate
Date dDFDate

Move 0 to dDFDate
Get DFDateToSQLDate of hoSQLStatement dDFDate SQL_TYPE_TIMESTAMP to sSQLDate

Will return 1753-01-01 in sSQLDate

String sSQLDate
Date dDFDate

Move 0 to dDFDate
Get DFDateToSQLDate of hoSQLStatement dDFDate SQL_TYPE_DATE to sSQLDate

Will return 0001-01-01 in sSQLDate