Datatype Conversion Within a SQL Statement
Frank Reinprecht <[email protected]>
| Newsgroups | gmane.comp.db.maxdb |
|---|---|
| Message-ID | <[email protected]> |
Dear readers,
I'm using sapdb 7.4 (I know it is a little bit old, but it works for me)
on a windows 2000 server. I made a mistake and filled the delivery date
of a customer-position with a wrong value. It was the wrong year.
So I used the following statement for correcting the year from 2006 to 2007.
update k_sonder_pos set liefertermin = Date('2007' &
SUBSTR(liefertermin,5,10)) where
liefertermin <= '2006-01-31' and liefertermin >= '2006-01-01'
This works as I expected very fine. But I now have the problem, that the
dates are shifted by one day. The 01.01.2006 is a sunday, and not like
the 01.01.2007 a monday. So I want decrease all the dates a day.
I tried different things, but without a conversion from string to number
and reverse I'm not able to solve it, I guess. Is there any possibility
to do so?
If anybody can help me out with this, please don't hesitate. I'm
thankfully for any hints!
Again thanks in advance!
Frank
--
MaxDB Discussion Mailing List
For list archives: http://lists.mysql.com/maxdb
To unsubscribe: http://lists.mysql.com/[email protected]