Dragos,
Monday, October 07, 2002, 7:30:47 PM, you wrote:
DMP> I am trying to run this update statement, but I got an error syntax...near
DMP> offsetCould You please point out what is wrong?
DMP> Update TIMEZONE_INFO set ABBREVIATION = 'GMT' || to_char(OFFSET) where
DMP> ABBREVIATION is null;
* Dragos Madalin Popa
> I am trying to run this update statement, but I got an error syntax...near
> offsetCould You please point out what is wrong?
>
> Update TIMEZONE_INFO set ABBREVIATION = 'GMT' || to_char(OFFSET) where
> ABBREVIATION is null;
Use the CONCAT function:
http://www.mysql.co
