I guess I'm sill learning. Does that mean that, if the last column in a load blabla. is a 0000-00-00 terminated by ^n it might error ? Or are we talking ODBC ?
On Wed, November 14, 2012 18:58, h...@tbbs.net wrote: >>>>> 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. > > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe: http://lists.mysql.com/mysql > > > -- > This message has been scanned for viruses and > dangerous content by MailScanner, and is > believed to be clean. > > -- Mogens Melander +66 8701 33224 -- This message has been scanned for viruses and dangerous content by MailScanner, and is believed to be clean. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/mysql