close Warning: Can't synchronize with repository "(default)" (/var/svn/tolp does not appear to be a Subversion repository.). Look in the Trac log for more information.

Opened 20 years ago

Closed 20 years ago

#192 closed defect (fixed)

Using DbTable()

Reported by: manuelb Owned by: manuelb
Priority: normal Milestone:
Component: DataBase Version: head
Severity: normal Keywords:
Cc:

Description

Hi to everybody:

I notice that the DDBB function

Set DbTable(Text qry)

is not able to report time in seconds!!!. I mean: suppose we have register en data
base with SQL datetime value

2004-11-02 17:01:31.000.

The value returned usign the above function DBTable() is

y2004m11d02h17i01s00.000.

Note that the date-part 'seconds' is now put to zero. It is possible to return the
whole datetime structure???

Best regards, Julio Navarro

Change History (2)

comment:1 Changed 20 years ago by manuelb

Status: new → assigned

comment:2 Changed 20 years ago by manuelb

Resolution: → fixed
Status: assigned → closed

The problemwas a bug in the second assigment:
It tried to assign (seconds+miliseconds)/1000 instead of:

seconds+(miliseconds/1000)

The solution is on the cvs by the time you are reading this.

Note: See TracTickets for help on using tickets.