Archives of the TeradataForum

Message Posted: Mon, 13 Oct 2003 @ 12:00:57 GMT

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

You could try this...

sel date + 1;

 *** Query completed. One row found. One column returned.
 *** Total elapsed time was 1 second.

(Date+1)
--------
03/10/14

 BTEQ -- Enter your DBC/SQL request or BTEQ command:
sel current_date - 2;

sel current_date - 2;

 *** Query completed. One row found. One column returned.
 *** Total elapsed time was 1 second.

(Date-2)
--------
03/10/11

Sanjaya

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