teradata linked table in access database how to format date in string

General
N/A

teradata linked table in access database how to format date in string

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?



note:

I use VB6 classic and ADO, and access 2100.



Tks.

Tags (3)
1 REPLY
N/A

Re: teradata linked table in access database how to format date in string

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.