I issue "select * from tab" against a set of tables, in order to copy the
contents of these source tables to the destination tables that have the
same column definitions. Since I do not want to deal with data types (thus
to_char is out of the question), the 'quoting' mechanism, which is part of
an example program oradump.pl (DBD-Oracle-1.12's Oracle.ex directory), came
in handy. However, I still needed a way to preserve the integrity of
timestamp fields.
As it turned out, the suggestion of issuing $dbh->do("alter session set
nls_date_format='MM-DD-YY HH:MI:SS'") works very well.
Thanks for all the replies,
Paul.
Joe Raube
<[EMAIL PROTECTED] To: Paul C
Shih/CA/KAIPERM@KAIPERM
> cc:
Subject: Re: Time component of Oracle
timestamp field unavailable.
06/11/2002 01:26
PM
What does your Select statement look like?
What does the same statement return in SQL*Plus?
You may need to use the to_date function to format the result..
-Joe
--- [EMAIL PROTECTED] wrote:
> Hello,
>
> My Oracle timestamp field returns only the date part when I
> select and
> fetch it. Is there any way to get the time as well?
> (DBI-1.25; DBD-Oracle-1.12; Oracle 8.1.7)
>
> Any suggestions/ideas would be appreciated.
>
> Paul.
>
__________________________________________________
Do You Yahoo!?
Yahoo! - Official partner of 2002 FIFA World Cup
http://fifaworldcup.yahoo.com
