Re: Syntax for cast?

[Carel <coteijgeler@xxxxxxxxx>]

Why do you use SQL Server syntax, as there is an DB2 SQL Reference 
manual online?

If you had used the right manual, you would have noticed that CONVERT is 
not the right syntax.

Regards,

Carel Teijgeler


Op 29-7-2016 om 16:29 schreef Hoteltravelfundotcom:
> this one is failing, its sql server syntax, I want to process only the
> previous week's sales.
>
>
> SELECT `OEINH2`.`IHDOCD`,
>   `OEINH2`.`IHINV#`,
>   `ADRES1`.`ADINTA`
>   FROM
>   ASTDTA`.`OEINH2` `OEINH2`
>   INNER JOIN `ASTDTA`.`ADRES1` `ADRES1`
>   ON `OEINH2`.`IHGRC#` = `ADRES1`.`ADENT#` + `ADRES1`.`ADSFX#`
>   WHERE
>   CAST(CONVERT(VARCHAR, `OEINH2`.`IHDOCD`) AS DATE) BETWEEN dateadd(wk,
> datediff(wk, 0, getdate()) - 1, 0) -1 AND dateadd(wk, datediff(wk, 0,
> getdate()) - 1, 0) + 6
>   ORDER BY `OEINH2`.`IHINV#`