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);
[related_post themes="text" id="204"]

Ambar Hasbiyatmoko

Hello, I’m web developer. Passionate about programming, networking and web server. @kaskus  @facebook

Leave a Reply

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

Time limit is exhausted. Please reload CAPTCHA.