Archives of the TeradataForum

Message Posted: Thu, 20 Jan 2011 @ 19:31:59 GMT

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

Hi,

Try;

     SELECT  Weekly Security report for the week of ' ||'0D'xc||
     CAST((DATE - 7) AS FORMAT 'ddBmmm' )||' - '||
     CAST(DATE AS FORMAT 'ddBmmmByyyy')(TITLE '');

Prashant

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