I am using a billing application called Saville Express to call a perl script and pass in a date. This is my prepare: $fetch_New_customers= $dbh->prepare(<<") || die "Can't prepare: $DBI::errstr\n "; #ataerr::dbprepare($dbh); select node_name, to_char(created_date,'MM-DD-YYYY'), to_char(active_date,'MM-DD-YYYY') from customer_node_history ch, (select customer_node_id, count(*) as cnt from customer_node_history group by customer_node_id) c where customer_node_status_code = 3 and c.customer_node_id = ch.customer_node_id and c.cnt = 1 and TO_CHAR(active_date,'MM-DDYYYY') > ? order by 1 If I pass in 08/20/2001, a record with an active_date of 12/31/2000 is returned. It's as if the month and day are compared , not the entire year. Has anyone experienced this? Kim Green Billing Systems Developer Madison River Communications 919.563.8385 [EMAIL PROTECTED] -- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
