problem with substring
Hi,
I've got a problem with a a query with the substring function.
I've got a table "travail" with a field "date" who's in vharchar.
Here is my query :
SELECT SUBSTRING(date from 0 for 2) from travail
but the result is empty rows.
I tried SELECT SUBSTRING(date,0,2) from travail but it's the same result.
But, SELECT SUBSTRING('Quadratically',5,6) gives the good result.
Does someone have an idea?
Thanks in advance and have a good day!
Subject
Written By
Posted
problem with substring
November 15, 2009 07:07AM
November 15, 2009 05:21PM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.