Results 1 to 3 of 3

Thread: BCP Date&Time

  1. #1
    Join Date
    Jun 2008
    Location
    India
    Posts
    96

    Unanswered: BCP Date&Time

    All,

    I have to upload date value into a table.

    format of the date value is

    01/01/2010 00:00:00

    i used 'd' in the .fmt file to upload the date. i have also tried 'c' for this. But none of them helped me to insert the date value into the table.

    how to do this?

    Inputs are welcome!

  2. #2
    Join Date
    Jun 2008
    Location
    India
    Posts
    96
    Content of Text file:


    28B0111N,02/04/2009 0:00:00,Act,ISHMSEMM,-0.10,0,0.10,-0.22,0.04,-0.04,-0.11,-0.07,02/06/2009 0:00:00
    28B0111N,02/04/2009 0:00:00,Mgd,ISHMSEMM,-0.28,0.19,0.02,0.01,-0.01,-0.01,0.01,-0.11,02/06/2009 0:00:00

    bcp emp..RiskIndex in RiskIndex.txt -fGL.fmt -Uuser -Ppass1 -SDEV_DS
    Attached Files Attached Files
    • File Type: txt GL.txt (492 Bytes, 48 views)

  3. #3
    Join Date
    May 2005
    Location
    South Africa
    Posts
    1,365
    Provided Answers: 1
    Quote Originally Posted by karthi_syb
    i used 'd' in the .fmt file to upload the date. i have also tried 'c' for this. But none of them helped me to insert the date value into the table.
    Don't know what you mean
    Quote Originally Posted by karthi_syb
    format of the date value is
    01/01/2010 00:00:00
    I assume that is month/day/year

    Your input file is plain text so you should use sybchar for all columns
    You probably don't need a format file if you pass -c -t,

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •