| List: | General Discussion | « Previous MessageNext Message » | |
| From: | Christopher R. Jones | Date: | June 3 1999 4:28pm |
| Subject: | Dates in MySQL | ||
| View as plain text | |||
I am not sure about other SQL databases but Visual Foxpro checks SQL
inserts for valid dates and if the date is invalid, a null value is
inserted. For example
INSERT into datatest (date1) values ("1997,02,29") creates the new record
but inserts a null value in the date1 field.
Christopher R. Jones, P.Eng.
14 Oneida Avenue
Toronto, Ontario M5J 2E3
Tel. 416 203-7465
Fax. 416 203-3044
Email cj@stripped
| Thread | ||
|---|---|---|
| • Dates in MySQL | Christopher R. Jones | 3 Jun |
| • Re: Dates in MySQL | Sasha Pachev | 3 Jun |
| • Re: Dates in MySQL | (Paul D. Smith) | 3 Jun |
| • Re: Dates in MySQL | Van | 4 Jun |
| • Re: Dates in MySQL | Benjamin Pflugmann | 5 Jun |
| • Re: Dates in MySQL | Jim Faucette | 5 Jun |
| • Not Null | Robert Pruitt | 5 Jun |
| • Re: Not Null | Paul DuBois | 5 Jun |