I'm trying to compare a datefield in an oracle table. Because of the field format, I have not been able to figure out a way to compare. I could really use some help. The field data looks like this (named = Activity_attempt_dttm); 11JUN2008:16:06:09.111000 12JUN2008:13:54:18.749000 This is the basic sql I’m trying to use; SELECT login_user_id, activity_attempt_dttm, audit_remark_txt FROM MAPTAB.SESA_SECURITY_AUDIT WHERE activity_attempt_dttm = "12JUN2008:13:54:18.749000"; The final solution for me is to be able to select data between a from date and a to date. I only need to compare the dates, not the time. Any help would be greatful. tbagger70
... View more