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