All Forums General
sal21 8 posts Joined 01/13
20 Jan 2014
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.

dnoeth 4628 posts Joined 11/04
21 Jan 2014

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.

Dieter

You must sign in to leave a comment.