Archives of the TeradataForum

Message Posted: Tue, 30 Oct 2012 @ 12:35:44 GMT

	<Prev	Next>		<<First	<Prev	Next>	Last>>

Have you tried this using bteq? (I do not use queryman / sql assistant) The query seems to work for me (although the extra cast is not required).

It is only necessary to have one case (the vc to date). It is not necessary to cast the date to a date because it is already a date. It is also not necessary to quote the declaration of "dt" as this is not a reserved word.

Thus this should be sufficient:

     sel
         cast(emp_dt as date format 'mm/dd/yyyy') dt from tblname where dt = current_date

I also tried this:

     sel
       cast(emp_dt as date format 'mm/dd/yyyy') dt,
       current_date,
       dt - current_date
     from tblname

To see what was happening.

Hope this helps

Glenn Mc

	<Prev	Next>		<<First	<Prev	Next>	Last>>