| 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.