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.

Thread
Issue regarding the import of the date from csv file to the table inthe database in mysqlsagar bs14 Nov
  • Re: Issue regarding the import of the date from csv file to the tablein the database in mysqlLarry Martell14 Nov
  • Re: Issue regarding the import of the date from csv file tothe table in the database in mysqlhsv14 Nov
    • Re: Issue regarding the import of the date from csv file to the tablein the database in mysqlsagar bs14 Nov
      • Re: Issue regarding the import of the date from csv file tothe table in the database in mysqlhsv14 Nov
        • Re: Issue regarding the import of the date from csv file to the table in the database in mysqlMogens Melander14 Nov
          • Re: Issue regarding the import of the date from csv file tothe table in the database in mysqlhsv15 Nov
Re: Issue regarding the import of the date from csv file to the table in the database in mysqlMogens Melander14 Nov
  • Re: Issue regarding the import of the date from csv file to the tablein the database in mysqlsagar bs14 Nov
Re: Issue regarding the import of the date from csv file to the table in the database in mysqlMogens Melander14 Nov
Re: Issue regarding the import of the date from csv file to the table in the database in mysqlMogens Melander14 Nov
  • Re: Issue regarding the import of the date from csv file to the table in the database in mysqlMogens Melander14 Nov