MySQL Forums
Forum List  »  Newbie

Re: Filtering Entries by Complex Date
Posted by: Phillip Ward
Date: November 05, 2014 06:49AM

Quote

Upstairs says not to change it, so I can't.
Yet another case of a supposed "Requirement" causing nothing but headaches and making no no sense at all to anyone who actually understands these things.

If you can't change this [utterly nonsensical] field, have you considered adding another field with a sensible, Date, value in it and populating that via a Trigger? That way, "Upstairs" can keep their field (that they're probably too scared to touch in case everything else breaks) but you can do Date things with a proper Date field.

Regards, Phill W.

Options: ReplyQuote


Subject
Written By
Posted
Re: Filtering Entries by Complex Date
November 05, 2014 06:49AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.