|List:||General Discussion||« Previous MessageNext Message »|
|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
|View as plain text|
>>>> 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.