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.)
Subject
Views
Written By
Posted
2486
January 06, 2013 01:00AM
Re: Create a New Datatype
1247
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.