Re: [SQL] how to update with a join?

2005-09-10 Thread MichaelHoeller
Hello all, thanks for the answere to the prev. thread. With the help of them I solved the problme I used "not like" instead of <> and this leads to a problem. This works for me: update stamm set code = replace (code, 'k' , '') where code like '%k%' and code <> '%V%'; I would still be intere

[SQL] date calculation

2003-08-21 Thread MichaelHoeller
Hi there, I have a problem calculating a date. A field carries the date as passed seconds since Jan 1st 1970. How can I get the date as dd.mm. out of this?? Thanks a lot Michael ---(end of broadcast)--- TIP 8: explain analyze is your friend