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:
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
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
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