DETECTDATE

  • {d<data>} - date
  • {t<data>} - time
  • {ts<data>} - timestamp

And binds the parameter appropriately, rather than as a character column. This is necessary if your server does not have a suitable native character string date representation (for example, Microsoft Access). It is also useful for generic applications. It can, however, cause problems if you have other character columns that can legitimately contain data that starts with "{d", "{t" or "{ts".

Syntax:

[NO]DETECTDATE

Properties:

Default: NODETECTDATE.