31 Ekim 2013 Perşembe

INFORMATICA Function get previous month first_day and last_day

Previous_month_first_day:
TO_CHAR
(
SET_DATE_PART
(
ADD_TO_DATE(sysdate,'MM',-1),
'DD',
1
)
, 'DD.MM.YYYY'
)


Previous_month_last_day:
TO_CHAR(

LAST_DAY( ADD_TO_DATE(sysdate,'MM',-1)   )

,

'DD.MM.YYYY'
)

Hiç yorum yok:

Yorum Gönder