HINT: Specify a USING expression to perform the conversion di postgresql

Masalahnya pas mau ngubah struktur kolom table dari character varying ke timestamp, malah error :

error change type timestamp column postgresql

nah solusinya, pake query sql manual

ALTER TABLE nama_table ALTER COLUMN nama_kolom TYPE timestamp without time zone USING (nama_kolom::timestamp without time zone);

Ambar Hasbiyatmoko

Hello, I'm web developer. Passionate about programming, web server, and networking.

Leave a Reply

Your email address will not be published. Required fields are marked *

Time limit is exhausted. Please reload the CAPTCHA.