Hi List,
it was, as everytime when nobody answers, too easy ;) After searching
again in the sqlstudio help I found what I need to solve it. I just
didn't took the right keywords while searching last time.
The solution (if somebody else perhaps need this) is:
update k_sonder_pos set
liefertermin = Date(
(SUBSTR(liefertermin,1,8)) & '0' &
SUBSTR(chr(NUM(SUBSTR(liefertermin,9,2)) -1),1,1)
)
where
liefertermin <= '2007-01-31' and liefertermin >= '2007-01-01'
Greetings,
Frank
--
MaxDB Discussion Mailing List
For list archives: http://lists.mysql.com/maxdb
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
