Hi all,
I'm trying to setup a constrain in table so that a date field conforms to a specific mask.
In ORACLE, it's something like
CONSTRAINT constraint_name
CHECK date_field
LIKE TO_DATE("DD/MMM/YYYY"
But I'm using MySQL?
Anyone know how I can port this???
Cheers
I'm trying to setup a constrain in table so that a date field conforms to a specific mask.
In ORACLE, it's something like
CONSTRAINT constraint_name
CHECK date_field
LIKE TO_DATE("DD/MMM/YYYY"
But I'm using MySQL?
Anyone know how I can port this???
Cheers