Archives of the TeradataForum

Message Posted: Wed, 06 Nov 2002 @ 13:45:11 GMT

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

<-- Anonymously Posted: Tuesday, November 05, 2002 16:36 -->

   alter table temp.TABLE_NAME
       add NEW_COLUMN DATE format 'yyyy-mm-dd'
                    default  date '2002-10-31';

yo! u b right on, bro.

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