Originally posted by stmontgo
it needs to be deterministic...that is when you execute the statement it will return the same result every time
Can you elaborate on the meaning? I don't understand how the function, to_date(column_name, 'MM-DD-RR') when used in a query, DOES NOT return same results every time.