postgresql error - convert [field] time to timestamp with time zone

Channel:
Ambar Hasbiyatmoko
Subscribers:
4,970
Published on ● Video Link: https://www.youtube.com/watch?v=fQzT9csFKgs


Duration: 2:11
3,467 views
2

i get this error when convert a field with TYPE 'time' to 'timestamp with timezone'

- the error :
HINT: You might need to specify "USING date::timestamp without time zone" in phpmyadmin - postgresql

in this video, i will show you how to fixing the error.



Other Videos By Ambar Hasbiyatmoko


2016-04-17Pgadmin problem(delete database) - ERROR: database "test" is being accessed by other users (Ubuntu)
2016-04-16Centos 7 - Install php and mysql from terminal
2016-04-15Centos 7 - Install GNOME Desktop in minimal Centos 7 64bit
2016-04-14Centos7 - Enable internet connection in *minimal centos7 64bit
2016-04-14Virtualbox - Install minimal Centos 7 64 bit (without GUI)
2016-04-13Codeigniter Error : Call to undefined function base_url()
2016-04-07ERMaster (Eclipse) problem - Cannot Export to DB (Postgresql)
2016-03-30PHP problem - Confirm Form Resubmission
2016-03-26Install latest Postgresql + Pgadmin from .run file - Ubuntu
2016-03-16Postgresql error : convert field character varying to integer
2016-03-15postgresql error - convert [field] time to timestamp with time zone
2016-02-22Android Studio error - The environment variable JAVA HOME does not point to a valid JVM installation
2016-02-22WAMP error - msvcr110.dll and msvcp110.dll is missing
2016-02-21WAMP error - #1405 Access denied for user 'root@localhost' using password no
2016-02-18Phppgadmin problem - empty SQL dump after export
2016-02-18Phppgadmin problem - Export error: Failed to execute pg dump [windows]
2016-02-07Codeigniter problem - Illegal string offset 'server' when using PostgreSQL
2016-02-07bootstrap-datepicker problem : options datepicker not working
2016-01-29Mysql error - Can't connect to local MySQL server through socket mysqld.sock
2016-01-24codeigniter problem : logout problem
2016-01-20phppgadmin problem : update query not working


Tags:
field
postgresql
alter table
tutorial
timestamp
phppgadmin