All Forums Database
Wahab-724 5 posts Joined 11/04
16 Jun 2009
TD12 Major Changes

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

saggitarian 2 posts Joined 06/09
18 Jun 2009

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 Date1 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-014 Select cast(cast(current_date as char(8)) || '01' as date) 06/01/2009 06/01/2009Teradata 12S.No Query fired on Teradata ANSIDATE Integer Date1 Select current_date 06/04/2009 06/04/20092 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/04014 Select cast(cast(current_date as char(8)) || '01' as date) 06/01/2009 Invalid DateRecently there was a patch upgrade on Teradata after which non-compliant ANSI dates are not accepted anymore when using ANSI dateform.

Wahab-724 5 posts Joined 11/04
19 Jun 2009

Any Other Major Changes in TD12?

Jim Chapman 449 posts Joined 09/04
19 Jun 2009

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.

You must sign in to leave a comment.