Tornado API Library - V12.30.08

z.dbSQLDateFormat Property

Date format required to build the correct date fields for edit SQL statements.

Product Version

All
[VisualBasic]
PublicPropertydbSQLDateFormatAsString
[C#]
publicstringdbSQLDateFormat{set;}

Property Value

Mydb.dbSQLDateFomat = "Date format string"

QuickProp Keyword Abbreviation

qdf

Remarks

This format is normally supplied by the system based on the dbType. Use this to override the defaults only in very special cases.

Example

Oracle -
  Mydb.dbSQLDateFomat = "TO_DATE('[d-MMM-yyyy H:mm:ss]','DD-MON-YYYY HH24:MI:SS')"
Access -  
  Mydb.dbSQLDateFomat = "#[M/d/yyyy H:mm:ss]#"
MS-SQL - 
  Mydb.dbSQLDateFomat = "'[M/d/yyyy H:mm:ss]'"
MYSQL -
  Mydb.dbSQLDateFomat = "'[yyyy-M-d H:mm:ss]'"
SYBASE -   
  Mydb.dbSQLDateFomat = "'[yyyy/M/d H:mm:ss]'"

See Also

z Class | Tornado Namespace | dbEditDateFormat