Skip to Content
0
Former Member
Sep 27, 2012 at 10:22 AM

Test date part of date/time in oracle sql command

30 Views

Hi, have an sql command which has a where clause selecting two dates from two crystal parms.

If I run report with same to/from days (as I just want to see 1 day) i get problems if a date type has a time portion set.

How can I mod the SQL command to just compare the date part of the oracle database with the crystal parms?

WHERE STMOD_HIST_DATE BETWEEN {?Reg Date From} AND {?Reg Date To})

date in database looks like 30/05/2012 09:40:55

thanks