chandra sekhar
asked on
How to retrive data which is having only DD/MM/YYYY format
My table having one varchar2 column,which is having all type of data formats inserted to into this table.
Now,i want to retrieve data which is records having DD/MM/YYYY format
please let me know,how to write.
Now,i want to retrieve data which is records having DD/MM/YYYY format
please let me know,how to write.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
My table having below date formats also
MM/DD/YYYY
DD/MM/YYYY
but your query retriving both formts ,need only DD/MM/YYYY format