Trouble retrieving proper DATE on a select

[scdarden]

My table has a DATE field which contains DATE/TIME info.  A general select
in sqlplus returns DATE/TIME, but the same select in perl only returns the
DATE.  It is critical that I get the TIME information too.

Any suggestions?

---------------------------------------

   $sth = $dbh->prepare( "SELECT * FROM $TABLE");
   $sth->execute;

   # FIELD NAMES
   @fields = @{$sth->{NAME}};

   $sth->bind_columns( \@data[0 .. $#fields] );
   while ( $sth->fetch ) {
      print "$data[4]\n";
      #$data = join( "~", @data );
      #push( @db, $data );
   }

---------------------------------------

Steve Darden