update the year in the date [message #289923] |
Wed, 26 December 2007 11:03 |
wannabee
Messages: 2 Registered: December 2007
|
Junior Member |
|
|
There are a few dates in the database date column which are added incorrectly... The year is 0003 instead of 2003... I want to keep the dates but change the year on those dates...
example: 22-Mar-0003 should be 22-mar-2003 ...
How do I write the update statement?
|
|
|
|
|
Re: update the year in the date [message #289930 is a reply to message #289927] |
Wed, 26 December 2007 11:58 |
joy_division
Messages: 4963 Registered: February 2005 Location: East Coast USA
|
Senior Member |
|
|
I think a better thing to do is find out the cause of these bad dates (well, it's because you are using 2 digits instead of 4 digits for dates of course, but WHERE is this happening?).
Forms?
front-end tool?
third-party product?
java/perl/etc?
|
|
|