I have a linked table from a teradata server database in accees database.
i need to get from teradata table all records where in teradata filed table DATE1>01/01/2000
how to format the date 01/01/2000 in sql string?
I use VB6 classic and ADO, and access 2100.
You can pass a date as a string '2000-01-01' but it must match the FORMAT of the target column.
There's only one recommended way to write a date in Teradata: DATE '2000-01-01', this always works regardless of any FORMAT.