utils/spacewalk-dump-schema | 5 ++++-
1 file changed, 4 insertions(+), 1 deletion(-)
New commits:
commit bb707b0c15b75345e9efe8f56184f213240d7136
Author: Jan Pazdziora <jpazdziora(a)redhat.com>
Date: Tue Sep 4 16:13:46 2012 +0200
Format the timestamps as well.
diff --git a/utils/spacewalk-dump-schema b/utils/spacewalk-dump-schema
index c460dc2..8bbb0d7 100755
--- a/utils/spacewalk-dump-schema
+++ b/utils/spacewalk-dump-schema
@@ -38,13 +38,16 @@ if (grep { defined $_ } $db, $user, $password) {
}
$ENV{NLS_LANG} = 'AMERICAN_AMERICA.UTF8';
+$ENV{NLS_DATE_FORMAT} = 'YYYY-MM-DD HH24:MI:SS';
+$ENV{NLS_TIMESTAMP_FORMAT} = 'YYYY-MM-DD HH24:MI:SS';
+$ENV{NLS_TIMESTAMP_TZ_FORMAT} = 'YYYY-MM-DD HH24:MI:SS TZH:TZM';
+
my $dbh = DBI->connect("dbi:Oracle:$options{db_name}", $options{db_user},
$options{db_password}, {
RaiseError => 1,
FetchHashKeyName => 'NAME_lc',
LongReadLen => 10_000_000,
LongTruncOk => 0,
});
-$dbh->do(q!alter session set nls_date_format = 'YYYY-MM-DD HH24:MI:SS'!);
print <<'EOS';
\set ON_ERROR_STOP on
Show replies by date