Convert date into timestamp before runnin the a query

From: leoh <leonardomachado_at_gmail.com>
Date: 25 Apr 2007 09:02:35 -0700
Message-ID: <1177516955.570763.210650@n15g2000prd.googlegroups.com>

Hello,

==> I have to run the following query

---

select * from tec_t_evt_rep where (date_reception> $begin and date_reception< $end) or (last_modified_time > $begin and last_modified_time < $end)

---

$begin => first timestamp
$end => last timestamp

==> The problem is, last_modified_time is VARCHAR in the date format
dd/mm/yy

Is it possible to create a query where last_modified_time is converted to timestamp before the query execution? Somenting like :

select (...) or (convert_timestamp(last_modified_time,'dd/mm/yy') and ...) Received on Wed Apr 25 2007 - 11:02:35 CDT