MySQL Forums
Forum List  »  Newbie

problem with substring
Posted by: mathias Dereymaeker
Date: November 15, 2009 07:07AM

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!

Options: ReplyQuote


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.