update date filed in tables?

From: <yliu_at_creighton.edu>
Date: Fri, 23 Apr 1999 09:22:11 -0500
Message-ID: <Pine.HPP.3.95.990423090919.28465A-100000@penguin.creighton.edu>

Hi all,

I have about a dozen tables that have a 'thrudate' field. Right now, most of the values of the 'thrudate' field are '31-dec-99' (some are not). I need to update that value to '31-dec-2099'? Does the following SQL work?

	update <table1>
	set thrudate = to_date('31-dec-2099', 'dd-mon-yyyy')
	where thrudate = to_date ('31-dec-99', 'dd-mon-yy') ;

All opinions are welcome.

Thanks in advance.

Yongge
yliu_at_creighton.edu Received on Fri Apr 23 1999 - 09:22:11 CDT