MySQL Forums
Forum List  »  Triggers

NEW variables in trigger don't contain user values
Posted by: Thomas CORBIERE
Date: October 26, 2005 03:03AM


I wished to insert DATE value in the french (DD/MM/YYYY) format and handle the transformation of the date to the MySQL format inside the trigger.

But before passing the date to the trigger, MySQL is validating the date and just because the date is invalid, MySQL transforms it to "0000-00-00".

I wonder why triggers don't get the exact value entered by the user.


Options: ReplyQuote

Written By
NEW variables in trigger don't contain user values
October 26, 2005 03:03AM

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.