I've bumped into something I don't understand with formatting of date/time values using the Export Tool. As you can see in the attached PNG showing the date and time formatting, there is a format mask specified that looks like "yyyy/MM/dd:hh:mm:ss a" and showing that it would end up looking like "2011/11/30:04:12:45 PM". First question is where is that format specified? The dialog sort of looks like there is supposed to a list of choices, but it is disabled and I need a different format. Second question deals with the fact that the export seems to be ignoring that format, and generating all of the date/times in the resulting input statements as 'yyyyMMdd hh:mm:ss.sss' format (see highlighted area in second PNG); what's going on there?
Looking at the on-line help documentation for the Export Tool, it talks about being able to set the export formats on the "General" panel of the Preferences. I've looked there but I don't see anything specifically relevant. Am I just missing it or is the doc out of date?
If it matters, when I run a query in the Query Analyzer, these same date/time columns come out formatted as 'MM/dd/yyyy h:mm:ss a' which is what I was hoping for here.