How can one validate a date in mysql ?

[Vankeerberghen, Pieter]

Dear Colleagues,
 
How can one validate a date in mysql ?
 
Kind regards,
Pieter

RE: How can one validate a date in mysql ?

[Vankeerberghen, Pieter]

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: Importing ACCESS into MYSQL

[Vankeerberghen, Pieter]

Dear Colleague,

Easily, install myODBC on your Windows PC, then export table to the ODBC
source.  To do this, in the Access DB window, select the table you want to
export, right-click on it, select save/export, choose the ODBC source. Table
is created automatically in mysql, values are exported.

Cheers,
Pieter

-Original Message-
From: Javier Garcia [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, March 14, 2001 2:54 PM
To: [EMAIL PROTECTED]
Subject: Importing ACCESS into MYSQL


Hi 

Does anybody know how to import MDB's into MYSql.

Thanks
Javier