Results 1 to 2 of 2
  1. #1
    Join Date
    Aug 2003
    Posts
    1

    Unanswered: BCP problem with datetime

    Im trying to use BCP to download a table with 3 datetime colums.

    file.out is like:
    Mar 2 2001 1:48:44 PM|Mar 4 2001 1:48:00 PM|Jan 1 1753 12:00:00 AM

    and i need the month name in spanish, cause sql loader cannot upload it to oracle server.

    sybase is in english. oracle in spanish. i cannot touch anything in the database config. Any idea?

  2. #2
    Join Date
    Feb 2002
    Location
    Willy is on vacation
    Posts
    1,208
    I guess, you could run the bcp file across "sed"(on UNIX) and replace those english names with spanish ones.

    Cheers,

    Willy

Posting Permissions

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