Welcome To The Home Of The Visual FoxPro Experts  
home. signup. forum. archives. search. google. articles. downloads. faq. members. weblogs. file info. rss.
 From: eijdor errotal
  Where is eijdor errotal?
 Catbalogan
 Philippines
 eijdor errotal
 Tags
Subject: MariaDB date issue
Thread ID: 373538 Message ID: 373538 # Views: 45 # Ratings: 0
Version: Visual FoxPro 9 SP2 Category: Other
Date: Saturday, March 23, 2013 3:21:44 AM         
   


Hi expert

how will i be able to insert a null value in a date field in mariadb?
i tested it in MYSql and it works well, but in mariadb it always prompt
an error..



i created a sample table named test and a date field (allow null), when i try to insert a data
using this sqlquery.

insert into test values ('01-02-1990') && results to null,this query has an error in mariadb
insert into test values ('null') && results to null,this query has an error in mariadb
insert into test values ('') && results to null,this query has an error in mariadb

ENTIRE THREAD

MariaDB date issue Posted by rodjie latorre @ 3/23/2013 3:21:44 AM
RE: MariaDB date issue Posted by tushar @ 3/23/2013 5:06:17 AM