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

Product Version

Property Value

Mydb.dbSQLDateFomat = "Date format string"

QuickProp Keyword Abbreviation

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

---