Inconsistent Date format in a Database

Database
Enthusiast

Inconsistent Date format in a Database

Hi,

Same table created by different users in same database have different date format ie. One has YYYY-MM-DD and other YY/MM/DD.

Is this due to table def stored on a different AMP with different date format setting at database level.

Thanks,

Abhi

1 REPLY
Teradata Employee

Re: Inconsistent Date format in a Database

Hi,

SHOW TABLE command can show the format of date columns for a table.   For each table it is the same on all AMPs.

Another story is that when users selects data from the table, then the format can change according to regional settings on the client side (depends on the client software).

Regards,

Vlad.