Post reply

BCP Question

  • July 30, 2002 at 8:05 am

    #79907

    Is it possible to BCP OUT with different date formats? I have a BCP file coming out of a table with the dateformat 'yyyy-mm-dd hh:mm:ss' but someone is requiring it as 'dd/mm/yy hh:mm:ss'

    Any ideas appreciated!

    Andy.

  • July 31, 2002 at 6:22 pm

    #433756

    Dont know. Why would it matter? A date is a date, formatting is normally a separate issue.

    Andy

    http://qa.sqlservercentral.com/columnists/awarren/

    Andy
    SQLAndy - My Blog!
    Connect with me on LinkedIn
    Follow me on Twitter

  • August 2, 2002 at 5:25 am

    #433889

    Thats what I thought Andy.

    However someone is trying to BCP this file back into a SQL Server 6.5 but getting errors on the dates unless they change the format??

    Andy.

  • August 2, 2002 at 8:36 am

    #433904

    BCP out using the QUERYOUT option rather than OUT, that way you can format the date how ever you want. If you've got something against QUERYOUT, then use a view.

    BCP "SELECT convert(CHAR(8), YourDateField, 103) + ' ' + convert(CHAR(8), YourDateField, 108), --your other columns-- FROM Database.Owner.YourTable" QUERYOUT yourtable.bcp -S...the usual bits...

    Edited by - nick beagley on 08/02/2002 08:43:28 AM

    Edited by - nick beagley on 08/02/2002 08:45:41 AM

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply