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

Dates in MySQLChristopher R. Jones3 Jun
  • Re: Dates in MySQLSasha Pachev3 Jun
  • Re: Dates in MySQL(Paul D. Smith)3 Jun
  • Re: Dates in MySQLVan4 Jun
    • Re: Dates in MySQLBenjamin Pflugmann5 Jun
  • Re: Dates in MySQLJim Faucette5 Jun
  • Not NullRobert Pruitt5 Jun
    • Re: Not NullPaul DuBois5 Jun