Object Reference

Classes
Command Interface
- xf_Command
External
- xf_External_VB6_32bit
- xf_External_VB7_32_64bit
General
System Core
System Library

xf_DbConnectDatabase Access Wrapper

Public Function DateTimeToSQLText (
d
) As String

Convert a date and time to text suitable for use in an SQL query, including date delimiters. Uses the DbConnect object's SQLStatementFormat setting to determine the correct Jet or MSSQL date delimiters

d as Variant

The date

Call Template:

Dim s As String

s = xf.DbConnect.DateTimeToSQLText(d)

Example 1:

Dim d as Date
d = #23/2/1982 13:40 PM#
Debug.Print xf.DbConnect.DateTimeToSQLText(d)
#23 Feb 1982 13:40 PM#   (in Australia!)

Object Reference

Public Function DateTimeToSQLText (d) As String

d as Variant

Call Template:

See Also:

Example 1:

Public Function DateTimeToSQLText (
d
) As String