CreateODBCTime

Syntax:

CreateODBCTime(dateexpr)

Description:
In order to use dates in a SQL language query, the date must be formatted properly. CreateODBCTime converts a BASIC time type to a string of text that is valid for use in a SQL Query through ODBC or OLEDB.

Parameter Description

dateexpr A valid time type or variant that can be converted to a time value

Example:

Sub Main
  myodbcdatetime = CreateOdbcTime(Time())
End
Sub

 

 

See Also:

CreateODBCDate

CreateODBCDateTime