Do you mean some entity called "SUBSTR for date functions" or use SUBSTR instead of date functions or use SUBSTR on the value returned by date functions ie can a date function be the first patrameter to SUBSTR?
What have you tried?
Thanks for your response Nic.
Let me make my query clear.
My question is that can we use SUBSTR function to the column which holds the date in DB2 table?
ex: Select SUBSTR(join_date,1,10) from employee table
join_date has data type as DATE in the employee table
Please let me know that whether SUBSTR function is applicable for VAR/CAHR only otherwise can we use it for DATE functions as well.