Archives of the TeradataForum

Message Posted: Fri, 03 Oct 2008 @ 21:28:45 GMT

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

Did you try:

     select t.cust_id,
        '20' || substr(rpt_dt,1,2) || '-' || substr(rpt_dt,3,2) || '-01' as
     RPT_DT, . . .

Mike Dempsey

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