When using Sybase's "bcp out" to a delimited file, fix the default date format to be something more portable (and sortable). This assumes a pipe delimited file, adding options to change that is left as an exercise. This is a function instead of a standalone script so that it can be included within another program.
BEGIN {
my $pgm = <<'EOT';
my @mon = qw( Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec );
my %mons;
my $i;
$mons{$_} = ++$i for @mon;
my $mon_str = join("|", @mon);
my $mon_re = qr/$mon_str/;
s/(^|\|)($mon_re)\s{1,2}(\d{1,2})\s(\d{4})\s\s?(\d\d?):(\d\d):(\d\d):(
+\d{3})([AP])M(\||$)/
$1.
sprintf("%04d-%02d-%02d %02d:%02d:%02d.%03d",
$4,
$mons{$2},
$3,
( $9 eq "P" && $5 < 12) ? $5 + 12 : ( $9 eq 'A' && $5 == 12 ) ? 0
+: $5,
$6,
$7,
$8).
$10
/eg;
EOT
sub fix_bcp_file {
my ($file) = @_;
system($^X, "-pi", "-e", $pgm, $file);
}
}