MEMBUAT FUNCTION POSTGRESQL TERBILANG TANGGAL BULAN DAN TAHUN

 Assalamualaikum Wr.Wb

Halo  Gan , Lama Banget Nih Udah ga Posting,

Ok Langsung Saja, Kali ini saya akan Membagikan Tutorial Membuat Function Terbilang tanggal bulan dan tahun di POSTGRESQL.

Pertama Buka SQL Editor Dan Tuliskan SCRIPT Berikut 

CREATE OR REPLACE FUNCTION terbilangbulankomplit(tgl date)

  RETURNS character varying AS

$BODY$

DECLARE

BULAN CHARACTER VARYING(250);

BEGIN

   IF    EXTRACT(MONTH FROM TGL) = 1 THEN

         BULAN = concat(EXTRACT(DAY FROM TGL) ,' ', 'Januari',' ',EXTRACT(YEAR FROM TGL));

   ELSIF EXTRACT(MONTH FROM TGL) = 2 THEN

         BULAN = concat(EXTRACT(DAY FROM TGL) ,' ', 'Februari',' ',EXTRACT(YEAR FROM TGL));

   ELSIF EXTRACT(MONTH FROM TGL) = 3 THEN

         BULAN = concat(EXTRACT(DAY FROM TGL) ,' ', 'Maret',' ',EXTRACT(YEAR FROM TGL));

   ELSIF EXTRACT(MONTH FROM TGL) = 4 THEN

         BULAN = concat(EXTRACT(DAY FROM TGL) ,' ', 'April',' ',EXTRACT(YEAR FROM TGL));

   ELSIF EXTRACT(MONTH FROM TGL) = 5 THEN

         BULAN = concat(EXTRACT(DAY FROM TGL) ,' ', 'Mei',' ',EXTRACT(YEAR FROM TGL));

   ELSIF EXTRACT(MONTH FROM TGL) = 6 THEN

         BULAN = concat(EXTRACT(DAY FROM TGL) ,' ', 'Juni',' ',EXTRACT(YEAR FROM TGL)); 

   ELSIF EXTRACT(MONTH FROM TGL) = 7 THEN

         BULAN = concat(EXTRACT(DAY FROM TGL) ,' ', 'Juli',' ',EXTRACT(YEAR FROM TGL));

   ELSIF EXTRACT(MONTH FROM TGL) = 8 THEN

         BULAN = concat(EXTRACT(DAY FROM TGL) ,' ', 'Agustus',' ',EXTRACT(YEAR FROM TGL));

   ELSIF EXTRACT(MONTH FROM TGL) = 9 THEN

         BULAN = concat(EXTRACT(DAY FROM TGL) ,' ', 'September',' ',EXTRACT(YEAR FROM TGL));

   ELSIF EXTRACT(MONTH FROM TGL) = 10 THEN

         BULAN = concat(EXTRACT(DAY FROM TGL) ,' ', 'Oktober',' ',EXTRACT(YEAR FROM TGL));

   ELSIF EXTRACT(MONTH FROM TGL) = 11 THEN

         BULAN = concat(EXTRACT(DAY FROM TGL) ,' ', 'Nopember',' ',EXTRACT(YEAR FROM TGL));

   ELSIF EXTRACT(MONTH FROM TGL) = 12 THEN

         BULAN = concat(EXTRACT(DAY FROM TGL) ,' ', 'Desember',' ',EXTRACT(YEAR FROM TGL));

   END IF;

     

RETURN BULAN;

END;

$BODY$

  LANGUAGE plpgsql VOLATILE

  COST 100;

  ALTER FUNCTION terbilangbulankomplit(date)

  OWNER TO postgres;

Seperti Ini

Lalu Klik Run

Setelah Berhasil bisa anda coba dengan cara menulis query berikut :

SELECT * FROM terbilangbulankomplit('2020-01-12')

Dan Hasilnya Seperti Berikut

Oke gan Itu saja Dari saya, Wassalamualaikum Wr. Wb