Re: How can one validate a date in mysql ?
Validate a date? see Date and Time functions in the manual. Vankeerberghen, Pieter wrote: Dear Colleagues, How can one validate a date in mysql ? Kind regards, Pieter - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: How can one validate a date in mysql ?
Thank you, Ok, I looked in the manual but I coul dnot obtain an answer. How can I check that a date I'm importing is valid, e.g. how to check for 20001131 (MMDD) ? Kind regards, Pieter -Original Message- From: Colin Faber [mailto:[EMAIL PROTECTED]] Sent: Tuesday, May 15, 2001 11:18 AM To: Vankeerberghen, Pieter Cc: [EMAIL PROTECTED] Subject: Re: How can one validate a date in mysql ? Validate a date? see Date and Time functions in the manual. Vankeerberghen, Pieter wrote: Dear Colleagues, How can one validate a date in mysql ? Kind regards, Pieter
Re: How can one validate a date in mysql ?
On Tue, May 15, 2001 at 11:27:19AM +0200, Vankeerberghen, Pieter wrote: Thank you, Ok, I looked in the manual but I coul dnot obtain an answer. How can I check that a date I'm importing is valid, e.g. how to check for 20001131 (MMDD) ? You'll have to do this kind of validation checks in your actual program that uses the MySQL interface, *before* executing the SQL statement itself. G'luck, Peter -- yields falsehood, when appended to its quotation. yields falsehood, when appended to its quotation. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: How can one validate a date in mysql ?
Dear Colleagues, How can one validate a date in mysql ? Kind regards, Pieter The simplest way that i know is: date_add(datestring, interval 0 day) This function wil return the correct date or NULL with months outside 1..12 and days outside 1..31. Here are some examples: select date_add('1999023', interval 0 day) - null select date_add('19990223', interval 0 day) -1999-02-23 select date_add('19990232', interval 0 day) - null select date_add('19990231', interval 0 day) -1999-03-03 Regards, Paul Paul B. van den Berg email: [EMAIL PROTECTED] Department of Social Pharmacy and Pharmacoepidemiology University Centre for Pharmacy tel:31-50-361 fax:31-50-3632772 Ant. Deusinglaan 1 9713 AV Groningen Netherlands - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php