Question: Update Year for a Date Field

From: Mai <mai_at_MCS.COM>
Date: 1996/01/03
Message-ID: <4cf341$rkn_at_Venus.mcs.com>#1/1

Does anyone know the SQL statements/functions to update Year for a DATE field in a table on Oracle???? i,e, update the value of a field from dd-MMM-95 to dd-MMM-94??? Without changing the values of Month and Day...

If you have an answer Please post or email me at mai_at_mcs.com.

Thanks a lot!! Received on Wed Jan 03 1996 - 00:00:00 CET

This message: [ Message body ]
Next message: Jeff Page: "Memory Resident Tables"
Previous message: Steve Butler: "Re: Reappearance of statistics!"
Next in thread: John Blackburn: "Re: Question: Update Year for a Date Field"
Reply: Robert C. Nix: "Re: Question: Update Year for a Date Field"
Reply: dan: "Re: Question: Update Year for a Date Field"
Reply: John Blackburn: "Re: Question: Update Year for a Date Field"

Contemporary messages sorted: [ by date ] [ by thread ] [ by subject ] [ by author ]

Original text of this message