| http://www.w3.org/ns/prov#value | - Nothing you do is going to be very efficient, because the best you can hope for is an index scan on jDate, if there is an index on that column.This should be faster than the LIKE, because the datediff and dateadd functions are much faster than conversions to strings.
|