[Gambas-user] [Gambas Bug Tracker] Bug #829: Unable to Insert Time value in postgresql database
bugtracker at ...3416...
bugtracker at ...3416...
Fri Oct 30 05:34:46 CET 2015
http://gambaswiki.org/bugtracker/edit?object=BUG.829&from=L21haW4-
Comment #3 by Safiur RAHMAN:
Hi
When I create Postgresql database using
hTable = $newCon.Tables.Add("tblimage")
hTable.Fields.Add("fldid", db.Serial)
hTable.Fields.Add("fldtime", gb.Date)
hTable.PrimaryKey = ["fldid"]
hTable.Update
It creates date field in timestamp without time zone format.
When I insert time only in this using datebox it tries to insert "0000-00-00" date before time (eg. 0000-00-00 10:14:00 ). This gives error.
More information about the User
mailing list