MySQL Forums
Forum List  »  Optimizer & Parser

Re: Create a New Datatype
Posted by: Rick James
Date: January 07, 2013 11:01PM

The best, nay, the _only_, environment would be one that handles the source code that MySQL is written in. That's not C#.

Your task is non-trivial. A better approach:
Develop some Stored Functions and Stored Procedures. They would take work with the intervals. You might be better off storing the intervals as two fields -- either DATE or INT. "1/5/2012" is a bad format to use -- it cannot be compared. It would be better to use the format that DATE uses: "2012-01-05". (That's the external format; internally it is similar to MEDIUMINT UNSIGNED.)

Options: ReplyQuote

Written By
January 06, 2013 01:00AM
Re: Create a New Datatype
January 07, 2013 11:01PM

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.