Date constraints

[jkscript]

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&quot

But I'm using MySQL?

Anyone know how I can port this???


Cheers

 

[sleipnir214]

Can you describe in greater detail what it is you are trying to do? ______________________________________________________________________

http://www.tuxedo.org/~esr/faqs/smart-questions.html

TANSTAAFL!

 

[jkscript]

I have a date field. and I want the data to be stored as
DD/MON/YYYY

how can I ensure this?

Cheers

 

[sleipnir214]

All MySQL dates are stored as YYYY-MM-DD -- that is its only available internal representation. There is no way to change that short of editing the source code and recompiling -- not something I recommend.

However, you can retrieve dates in any reasonable format you want using MySQL's date_format() function. ______________________________________________________________________

http://www.tuxedo.org/~esr/faqs/smart-questions.html

TANSTAAFL!