From: hsv Date: November 14 2012 5:58pm Subject: Re: Issue regarding the import of the date from csv file to the table in the database in mysql List-Archive: http://lists.mysql.com/mysql/228624 Message-Id: MIME-Version: 1.0 Content-Type: text/plain; charset="us-ascii" >>>> 2012/11/14 18:27 +0530, sagar bs >>>> There are four columns in my table named like account_name, c1, c2 and c3. Account name is the primary key and c1, c2 contain two different dates and in the column c2 there are few fields showing 0000/00/00, now i need to get the date different(in days) between the dates present in the c1 and c2. That days should be shown in the c3. please help me out. <<<<<<<< Try DATEDIFF. As for date 0000/00/00, MySQL s treatment of NULLs in CSV files is peculiar: it wants the escape NULL or \N, separator right after separator is not NULL, but empty string. Consider those NULL.