http://gambaswiki.org/bugtracker/edit?object=BUG.829&from=L21haW4-
Safiur RAHMAN reported a new bug. Summary ------- Unable to Insert Time value in postgresql database Type : Bug Priority : High Gambas version : 3.8 Product : PostgreSQL driver Description ----------- I supply Time value from DateBox which is in TimeOnly mode In MySQL I can insert Time easily res["fldtime"] = DateBox1.Value In gambas 3.7 I could insert Time value in PostgreSQL as res["fldtime"] = Time(DateBox1.Value) In gambas 3.8 I can't insert Time value res["fldtime"] = DateBox1.Value gives error res["fldtime"] = Time(DateBox1.Value) gives error Is there any other standard way of inserting Time into postgresql database System information ------------------ [System] Gambas=3.8.2 OperatingSystem=Linux Kernel=3.19.0-31-generic Architecture=x86_64 Distribution=Ubuntu 14.04.3 LTS Desktop=GNOME Theme=Gtk Language=en_US.UTF-8 Memory=3884M [Libraries] Cairo=libcairo.so.2.11301.0 Curl=libcurl.so.4.3.0 DBus=libdbus-1.so.3.7.6 GStreamer=libgstreamer-0.10.so.0.30.0 GStreamer=libgstreamer-1.0.so.0.204.0 GTK+2=libgtk-x11-2.0.so.0.2400.23 GTK+3=libgtk-3.so.0.1000.8 OpenGL=libGL.so.1.2.0 Poppler=libpoppler.so.44.0.0 QT4=libQtCore.so.4.8.6 QT5=libQt5Core.so.5.2.1 SDL=libSDL-1.2.so.0.11.4 [Environment] CLUTTER_IM_MODULE=xim COMPIZ_BIN_PATH=/usr/bin/ COMPIZ_CONFIG_PROFILE=ubuntu DBUS_SESSION_BUS_ADDRESS=unix:abstract=/tmp/dbus-k0VpE3F2xZ DEFAULTS_PATH=/usr/share/gconf/ubuntu.default.path DESKTOP_SESSION=ubuntu DISPLAY=:0 GB_GUI=gb.qt4 GDMSESSION=ubuntu GDM_LANG=en_US GIO_LAUNCHED_DESKTOP_FILE=/usr/share/applications/gambas3.desktop GIO_LAUNCHED_DESKTOP_FILE_PID=23066 GNOME_DESKTOP_SESSION_ID=this-is-deprecated GNOME_KEYRING_CONTROL=/run/user/1000/keyring-IGSXyK GNOME_KEYRING_PID=2260 GPG_AGENT_INFO=/run/user/1000/keyring-IGSXyK/gpg:0:1 GTK_IM_MODULE=ibus GTK_MODULES=overlay-scrollbar:unity-gtk-module HOME=<home> IM_CONFIG_PHASE=1 INSTANCE= JOB=dbus LANG=en_US.UTF-8 LANGUAGE=en_US LC_ADDRESS=ne_NP LC_IDENTIFICATION=ne_NP LC_MEASUREMENT=ne_NP LC_MONETARY=ne_NP LC_NAME=ne_NP LC_NUMERIC=ne_NP LC_PAPER=ne_NP LC_TELEPHONE=ne_NP LC_TIME=ne_NP LOGNAME=<user> MANDATORY_PATH=/usr/share/gconf/ubuntu.mandatory.path PATH=/usr/local/sbin:/usr/local/bin:/usr/sbin:/usr/bin:/sbin:/bin:/usr/games:/usr/local/games PWD=<home> QT4_IM_MODULE=xim QT_IM_MODULE=ibus QT_QPA_PLATFORMTHEME=appmenu-qt5 SELINUX_INIT=YES SESSION=ubuntu SESSIONTYPE=gnome-session SESSION_MANAGER=local/<hostname>:@/tmp/.ICE-unix/2421,unix/<hostname>:/tmp/.ICE-unix/2421 SHELL=/bin/bash SHLVL=0 SSH_AUTH_SOCK=/run/user/1000/keyring-IGSXyK/ssh TEXTDOMAIN=im-config TEXTDOMAINDIR=/usr/share/locale/ TZ=:/etc/localtime UPSTART_SESSION=unix:abstract=/com/ubuntu/upstart-session/1000/2262 USER=<user> XAUTHORITY=<home>/.Xauthority XDG_CONFIG_DIRS=/etc/xdg/xdg-ubuntu:/usr/share/upstart/xdg:/etc/xdg XDG_CURRENT_DESKTOP=Unity XDG_DATA_DIRS=/usr/share/ubuntu:/usr/share/gnome:/usr/local/share/:/usr/share/ XDG_GREETER_DATA_DIR=/var/lib/lightdm-data/<user> XDG_MENU_PREFIX=gnome- XDG_RUNTIME_DIR=/run/user/1000 XDG_SEAT=seat0 XDG_SEAT_PATH=/org/freedesktop/DisplayManager/Seat0 XDG_SESSION_ID=c2 XDG_SESSION_PATH=/org/freedesktop/DisplayManager/Session0 XDG_VTNR=7 XMODIFIERS=@im=ibus ------------------------------------------------------------------------------ _______________________________________________ Gambas-user mailing list Gambas-user@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/gambas-user