From: | "Alejandro Michelin Salomon \( Adinet \)" <alejmsg(at)adinet(dot)com(dot)uy> |
---|---|
To: | "Pgsql-General" <pgsql-general(at)postgresql(dot)org> |
Subject: | How to add days to date |
Date: | 2006-08-16 01:10:27 |
Message-ID: | !~!UENERkVCMDkAAQACAAAAAAAAAAAAAAAAABgAAAAAAAAAhx491Ki2tUS42D/aMPFg1MKAAAAQAAAA6qyMHqYsDEaPzs7YGVsxdQEAAAAA@adinet.com.uy |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
Hi:
I have problem trying to add same days to a date.
I have this select :
SELECT '2006-08-01' + FP.carencia + ( FP.prazo * ( MFP.parcela - 1 )) AS
vencimento
FROM fi_mov_formas_pagamento MFP
LEFT OUTER JOIN fi_formas_pagamento FP ON ( MFP.idformapagamento =
FP.idformapagamento AND MFP.idempresa = FP.idempresa )
INNER JOIN hd_cabecalho HDC ON ( MFP.idmovimento = HDC.idhelpdesk AND
MFP.idempresa = HDC.idempresa )
WHERE MFP.idmovimento = 1
AND MFP.idempresa = 1
AND MFP.idtipomovimentacao = 1
'2006-08-01' + FP.carencia + ( FP.prazo * ( MFP.parcela - 1 )) --> This
results in
EX :
'2006-08-01' + 30 + ( 7 * ( 3 - 1 )) ==> '2006-08-01' + 44
All my trys fails.
Can you help me ?
Thanks in advance.
Alejandro Michelin Salmon
From | Date | Subject | |
---|---|---|---|
Next Message | Michael Fuhr | 2006-08-16 01:16:56 | Re: How to add days to date |
Previous Message | Harvey, Allan AC | 2006-08-15 23:17:19 | Re: plpgsql dynamic queries and optional arguments |