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