what is the SQL to display a number (200909) as Sep 2009 in Teradata 12 -

-

What is SQL to display a number (200 9) in TerraData 12 in September 2009

Teratata Store dates as integer as follows: 

  (year - 1900) * 10000 + (months) 
 
 
 * 100) + day

Then you remove 1900 from the year and add one day to make the number one valid date, then that Enter the format that only shows months and years. 

  Choose Cast (CAST ((2009-09-1900) * 100 + 1 AS DATE format 'm3by4') as (8));

Comments

Post a Comment