Hi,
I use bcp out to output table data to a file but I have a problem with date and number formats. I want to understand what creates these formats and is it possible to change these.

bcp mydb.dbo.mytable out data_3004_3004.dat -c -t~!~ -r~_!_~ -SASOS -UMYUSR -PMYPASS

To be more specific about what I need
1-)Date columns has a format like "Oct 22 2000 12:00:00:000AM" I want to understand what creates "Oct" part in the format because it is language specific so there has to be a way to change this I think.
2-)Also number columns has "." for before their decimal parts, I don't have a problem with that but I want to understand why it is so, if it is language specific it might turn into "," next time I change language settings

Thanks in advance

You can make a view on that table in which you convert the date to another format (like 22/08.2000 12:00:00:000AM ).

BCP itself does not have this functionality as far as I know.

creating a view might be solution but, I think there should be another solution.

What is exactly causing English month names?

English is the default language in Sybase. You could try installing a different language. That might give you translated monthnames, but it would still be in the same format.

Ok, thanks.
I guess I have no choice but to use view