[Gambas-user] [Gambas Bug Tracker] Bug #829: Unable to Insert Time value in postgresql database

[bugtracker at ...3416...]

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=@...3498...=ibus