Re: Datatype Conversion Within a SQL Statement

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]