|
Posted by Thomas Bartkus on 12/23/05 18:18
"Dale" <dale@nospam.com> wrote in message news:lPqqf.163$6K2.122@edtnps90...
> Is there a way to change how MySQL interprets a 2 digit year? Currently a
2
> digit year between 00-69 is interpreted as 2000-2069. I have more than a
> million records that fall between 00-69 where many of them are valid 1900
> dates. I would like to change the interpretation rules to be more like
> 00-15 as 20th century and the remainder being 19th century recognizing
this
> is not a failsafe method either...but it more approximates what my data
is.
Maybe!
But why not just go with the flow?
Is there any reason why you wouldn't want to bulk update your records to a
more sensible 4 digit year and end the confusion once and for all?
Failsafe is easy. Why not go for it?
Thomas Bartkus
Navigation:
[Reply to this message]
|