Re: update date filed in tables?

From: Arjan van Bentem <avbentem_at_DONT-YOU-DAREdds.nl>
Date: Sat, 24 Apr 1999 10:22:17 +0200
Message-ID: <7fruvb$i35$1@weber.a2000.nl>

Patrick Suppes wrote
> To say this in yet a different way, Yongge's assertion that the sql clause
"where
> thrudate = to_date ('31-dec-99', 'dd-mon-yy') " does not exactly match
his/her
> stated goal of updating thrudates with the formatted value of '31-dec-99'.
The
> specific gaps I identified could be fixed by using a character-based
comparison
> instead of using a date-based comparison.

You are right. I misunderstood the idea behind your solution, and should not have reacted the way I did. Excuse me for that.

To enhance your solution a bit, I guess

where to_char(thru_date, 'dd-mon-yy') = '31-dec-99'

would be the best solution. Yongge: note that 'mon' returns 'dec' while 'Mon' returns 'Dec', etc.

Arjan. Received on Sat Apr 24 1999 - 03:22:17 CDT