FiveTech Software tech support forums

... ) // one existing record oStatesRec:Edit() // modify and save the existing record - Methods CreateTable() and ImportFromDBF() used to create DateTime and TimeStamp fields without support for fraction of seconds. Now support fraction of seconds milliseconds. - Improved support for Restoring ...

Dear Antonio,

thank you very much...this is wonderful!!!
it is running now

have a nice weekend and kind regards
ruth

Dear Ruth, good morning I just copied and pasted your post into chatgpt and the answer seems fine :-) (not exactly correct, but the explanation seems fine) Yes, it looks like the timestamp you provided is in milliseconds since the Unix epoch. To convert a Harbour date variable into a Unix timestamp ...

dear all, I would also like to kindly ask assistance with date and time handling. specifically: is it possible to convert a harbour date variable into a "unix timestamp expressed in milliseconds" (hope this is the correct term)? I am working on a project where I need to pass arrival and de...

Hi Rao, thank you. I had found it in xHarbour documentation

I figured it out.

Hello,

Is it possible to perform a DateTime calculation to get current time minus 10 minutes? For example

cTenMinutesBefore := DateTime() - 10

Thank you!

Working perfectly for me too here: This is my code:    ? "NOW()=", Now(), "HB_DATETIME()=", ;      HB_DateTime(), ;     "Current time: " + FW_Transform( HB_DateTime(), "ddd mmm dd hh:mm:ss yyyy" ) Result: https://imagizer.imageshack.com/v2/xq70/923/4qyZqS.png ...

... "fldint", "fldtext", "fldbool", "fldDate" }, ;               { 99, "FiveWin", .t., hb_DateTime() } )   oRs:MoveFirst()   aTypes   := {}   for n := 0 to oRs:Fields:Count - 1      WITH OBJECT oRs:Fields( ...

... b) Whatever numeric datatype, like int, numeric(w,d), etc we specify the columns are finally double only. c) Date fields accept both dates and datetime values. d) Use field type "TEXT" for memo fields. To have better control of column formatting we need to create Excel Sheets using ...

... [testdt] ( [NAME]     VARCHAR(20), [JGDATE]   DATE, [TSTAMP]   DATETIME )ENDTEXT   oCn:Execute( cSql )   oRs   :=  FW_OpenRecordSet( oCn, "select * from [testdt]" ...

hi,

sorry, i mean Structure of Excel Sheet create by ADO

it did accept DATETIME in Structure for a Excel Sheet, but when XBROWSE / EDIT it fail
i have to change back to DATE to make it work again

hi, have found out that TDataRow():New() does not like Type DATETIME, only DATE Is it? Test: #include "fivewin.ch"function Main()   DBCREATE( "testx.dbf", { ;      { "ID", "+", 4, 0 }, ...

hi,

have found out that TDataRow():New() does not like Type DATETIME, only DATE