July 30, 2002 at 8:05 am
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
Dont know. Why would it matter? A date is a date, formatting is normally a separate issue.
Andy
August 2, 2002 at 5:25 am
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
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