Hello, try wrapping your trunc(date,'hh') inside a to_char(<date>,'<format>') as in
SELECT to_char(trunc(date,'hh'),'YY-MON-DD HH24:MI') from ... You can use any format description you want. Jean-Claude -----Original Message----- From: Richard Phillips [mailto:[EMAIL PROTECTED]] Sent: January 3, 2002 1:10 PM To: '[EMAIL PROTECTED]' Subject: Oracle dates Hello All, Does the perl DBI handle oracle dates as simple scalars? I'm running a query that returns a trunc(date,'hh'). This does return the full date truncated to the hour. BUT when I call fetchrow_array I get a string with just the day-mon-year. It seems to be chopping off my hour. Any thoughts? -rp
