Hi, hope you all are doing fine.
My query is regarding creating a table with two insert statements. Here's a summary:
Create Table Table1 AS
SUM(... A sum statement...) AS "Budget",
MAX( ... A max statement ... as DATE ) ELSE NULL END ) AS "Last Update Date"
From (...bunch of statements)
Where (...bunch of statements)
2) with Data;
Alter Table Table1
ADD "New field 1"
Insert into Database.Table1
SUM(... A sum statement...) AS "New Field 1",
My query is failing with 2665: Invalid data format (which is probably got to to with 1990/01/01. My question to you here is what is the correct data format to be used in Teradata?
Thanks for your time, and have a great day,
It's DATE '1990-01-01'