TD12 Major Changes

Database
Enthusiast

TD12 Major Changes

Can you please let me know what all are Major Changes/Features implemented in TD 12.
3 REPLIES

Re: TD12 Major Changes

One major change which I noticed was regarding CAST function or may be all the functions using ANSI dates.

Teradata 8

S.No Query fired on Teradata ANSIDATE Integer Date
1 Select current_date 06/04/2009 06/04/2009
2 Select cast(current_date as char(8))* 2009-06- 2009-06-
3 Select cast(current_date as char(8)) || '01 2009-06-01 2009-06-01
4 Select cast(cast(current_date as char(8)) || '01' as date) 06/01/2009 06/01/2009

Teradata 12

S.No Query fired on Teradata ANSIDATE Integer Date
1 Select current_date 06/04/2009 06/04/2009
2 Select cast(current_date as char(8))* 2009-06- 09/06/04
3 Select cast(current_date as char(8)) || '01 2009-06-01 09/06/0401
4 Select cast(cast(current_date as char(8)) || '01' as date) 06/01/2009 Invalid Date

Recently there was a patch upgrade on Teradata after which non-compliant ANSI dates are not accepted anymore when using ANSI dateform.

Enthusiast

Re: TD12 Major Changes

Any Other Major Changes in TD12?
Enthusiast

Re: TD12 Major Changes

Every major release has a long list of major enhancements. You can read about it in the Release Summary, which you can download from this site.