Read the Oracle docs ... Character functions ----------------- Ron Reidy Lead DBA Array BioPharma, Inc.
-----Original Message----- From: Denesa K Shaw [mailto:[EMAIL PROTECTED] Sent: Wednesday, May 11, 2005 6:17 AM To: [email protected] Subject: Select Statements using a Formatted Date Hi, How do get the date to be in the format like this? mm/dd/yyyy hh24:mi:ss When I run this code It prints: START TIME: 01-JAN-05, END TIME: 02-JAN-05 Thanks in advance! Here is what I have: my $sql = qq{SELECT MIN(RELOAD_FILE_TS),MIN(RELOAD_FILE_TS)+ 1 FROM T_RELOAD WHERE LAST_ATTEMPT_TS IS NULL}; my $sth = $dbh->prepare( $sql ); $sth->execute(); my($starttimeStamp,$endtimeStamp); $sth->bind_columns( undef,\$starttimeStamp,\$endtimeStamp); ##$sth->bind_columns(":fmt","mm/dd/yyyy hh24:mi:ss"); while( $sth->fetch() ) { print "START TIME: $starttimeStamp, END TIME: $endtimeStamp\n"; } $sth->finish(); } This electronic message transmission is a PRIVATE communication which contains information which may be confidential or privileged. The information is intended to be for the use of the individual or entity named above. If you are not the intended recipient, please be aware that any disclosure, copying, distribution or use of the contents of this information is prohibited. Please notify the sender of the delivery error by replying to this message, or notify us by telephone (877-633-2436, ext. 0), and then delete it from your system.
