Query query misian

---------------------------
isi data nya :

source_time
3/17/2019

kurang 1 bulan

SELECT
  to_char(source_time,'yyyyMM') as batch_date,
to_char(source_time+'-1 MONTHS'::INTERVAL,'yyyyMM') as periode_prev
FROM parameter_date

Result :

batch_date periode_prev
201903         201902

-------------------------------

isi data nya :

source_time
3/17/2019

query, hasil :

SELECT
to_char(source_time,'yyyymm') as periode
from parameter_Date


result :

periode
201903

Tweet