[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