I am really new to Teradata. I am creatinting some report using (SSRS) directly from Teradata source so i am trying to develop queries in Teradata SQL assistant.
So can one plesase let me know where i can ge basic queires of Teradata especially with date in where condition.
Aslo can any plese help me with this basic query
Select top 1 * FROM
I got below error
error: character string failed conversion to numeric
there's only one recommended way to write a date, DATE followed by a string with 'yyyy-mm-dd' format (Standard SQL):
where VCTD700.CLOSED_DT= DATE '2012-07-10'
Regarding date calculations, most SQL Server syntax can be easily converted, what are you looking for?
DATEADD days -> DATE +/- INTEGER
DATEADD months -> ADD_MONTHS
DATEDIFF days -> DATE2- DATE1
Is there anyone who could provide an idea on how to start writing rules in Abinitio BRE.Any documentation or any link online that can be used as a start guide.I am new to this and will really appreciate if anyone could help me out.