A bcp question

• Haiyan Sui

  Newbie

  Points: 1

  More actions

  April 4, 2005 at 1:16 pm

  #61847

  We are using BCP to extract data from a table into a text file. Below is the BCP command. The problem is running it from different client machines gives us different date format in generated text file.

  bcp DBNAME.TABLENAME out %dir%\TABLENAME.dat /c /t "^" /S SERVERNAME /U USERNAME /P PASSWORD

  The date format on one client machine is simply yyyy-mm-dd, while on the other one is yyyy-mm-dd 00:00:00.000. We checked the version of BCP on both clients are 8.00.194

  Thanks for any idea.

   

• Jim Guffey

  SSC Rookie

  Points: 42

  More actions

  April 4, 2005 at 4:46 pm

  #550427

  Try this article

  http://msdn.microsoft.com/library/default.asp?url=/library/en-us/adminsql/ad_impt_bcp_2lv4.asp