Teradata basic query

Database

Teradata basic query

Hi all,

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.

Thanks,

jyo

3 REPLIES

Re: Teradata basic query

Aslo can any plese help me with this basic query

Select top 1 * FROM

A_VIEWS.VCTD700  VCTD700

      where  VCTD700.CLOSED_DT='7/10/2012'        

I got below error

error: character string failed conversion to numeric

Thanks,

Jyo

Junior Contributor

Re: Teradata basic query


Hi Jyo,



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



 



Dieter


N/A

Re: Teradata basic query

Hi there,

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.