vendredi 5 août 2016

SQL2005 - DATE ADD AND GETDATE DOESN'T WORK

I have a very strange error in a SQL query and I don't understand why.

SELECT 
            CODCLIFOR,      '', 
            DSCCONTO1,      '',  
            NUMDOC,      '', 
            NUMSCAD,      '', 
            DATASCADENZA,      '', 
            REPLACE(CONVERT(varchar, CAST(IMPORTOSCLIT AS money), 105),',','.') ,       '', 
            BANCAAPPCF.BANCAAPPOGGIO,    '',
            TIPIEFFETTI.DESCRIZIONE
            FROM dbo.TABSCADENZE
            INNER JOIN dbo.ANAGRAFICACF ON CODCLIFOR = CODCONTO
            INNER JOIN dbo.TIPIEFFETTI ON TIPOEFFETTO = EFFETTO
            LEFT JOIN dbo.BANCAAPPCF ON CODCLIFOR = BANCAAPPCF.CODCONTO AND BANCAAPPCF.CODICE = TABSCADENZE.BANCAAPPOGGIO
            WHERE    TIPOEFFETTO = 2  AND DATASCADENZA ='2016-08-05' AND CODCLIFOR LIKE '%C%'
            ORDER BY BANCAAPPCF.BANCAAPPOGGIO DESC

On date DATASCADENZA in the where condition, if I put the today date like '2016-08-05' I've results.. instead if I use GETDATE() or DATEADD(DAY,3,GETDATE()) I obtain 0 results... I don't understand why. Can you help me? Thank you!

Aucun commentaire:

Enregistrer un commentaire