Results 1 to 2 of 2
  1. #1
    Join Date
    Jul 2002
    Posts
    1

    Unanswered: DTS/bcp a date into a datetime column

    Is it possible to bcp a date like '1990-01-01' into a datetime column? The flat file does not contain any time.

    I know it is possible using DTS and VB but I am trying to avoid this method. For those familiar with Oracle SQL Loader, you can specify a date format or date conversion function in a control file. I am wondering if I can use the function convert() in some similiar manner.

    Thanks,
    TPH

  2. #2
    Join Date
    Feb 2002
    Location
    Houston, TX
    Posts
    809
    BCP will handle all reccognized date formats. You do not need to do any type of conversions.
    Paul Young
    (Knowledge is power! Get some!)

Posting Permissions

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