SQLDateToDFDate - cSQLStatement

Converts an SQL DateTime data type to a string in DataFlex Date data type format

Type: Function
Return Data Type: Date

Parameters

Parameter	Type	Description
sSQLDate	String	SQL DateTime value to convert

Syntax

Function SQLDateToDFDate String sSQLDate Returns Date

Call Example

Get SQLDateToDFDate sSQLDate to DateVariable

Description

Converts an SQL DateTime data type to a string in DataFlex Date data type format.

Sample

Handle hStmt
String sValue
Date dValue
:
Get SQLColumnValue of hStmt 13 to sValue
Get SQLDateToDFDate of hStmt sValue to dValue

See Also

SQLColumnValue | Time and Date Functions

Return Value

String formatted as DataFlex date type