FiveTech Software tech support forums

... static function ParseDateTime( cDateTime ) local dDate, cTime cTime := SubStr( cDateTime, 12, 8 ) dDate := STOD( StrTran( Left( cDateTime, 10 ), "-", "" ) ) return { dDate, cTime } /*** JSON below {"vessel":{"vesselIMONumber":"9332999","carrierVesselCode":"Q4F","vesselName":"MAERSK ...

... dDataFinaleSET DATE ITALIANdDataIniziale:= ctod("04/07/2021")dDataFinale:= ctod("08/07/2021")  OR use STOD() which is safe whatever is the date format local dDataIniziale:= STOD( "20210704" )local dDataFinale  := STOD( "20210708" ...

... 0 hours 0 mins 9 secs Error occurred at: 30/03/2021, 18:51:24 Error description: Error BASE/1132 Error de rango: acceso al array Args: [ 1] = A {SToD("20210308"),"00020108 ",2,108,"AJO/S SOLAR DEL GENERAL S.A.",109,"VISCUSSO FA ... } [ 2] = N 16 Stack Calls ...

Hola. usando harbour y Fwh la ultima. Me arroja estos errores: [1]:iLink32.Exe -Gn -q -aa -Tpe -x @testMaria.bcl Error: Unresolved external 'WinMain' referenced from X:\HARB\BCC7\LIB\C0W32.OBJ Error: Unresolved external '_hb_vmProcessSymbols' referenced from X:\PROYECTOS\TEST\MARIA\OBJ\MARIA.OBJ Err...

oRs:Date := STOD( "20150815" ) oRs:Update() Great! Thank you Rao. With SQL syntax is ok, using Recordset only a correction i had to make compared to the two rows above: oRs:fields("Date"):value := STOD( "20150815" ...

... and dDataFinale and I have set date Italian on dbf I have the date as 16/07/18 how I can make to have and use as your test dDataIniziale := STOD( "20180701" ) ?

... Till you set the date format is the default format "mm/dd/yy". 14 as month is invalid. To avoid such mistakes it is a good idea to use STOD( "20190814" ). This does not depend on date format.

... with Emagdbu.exe a record. But FILESTATS() shows not the correct date of changing. I use xHarbour. "c:\xkm\T__058.dbf" dCreated = SToD("20180328") nCreateTime = 68501 "c:\xkm\T__058.dbf" dChangeDate = SToD("20180328") nChangeTime = 68501 http://www.atzwanger-software.com/fw/createtime.jpg

... SoundEx(<cString>)->cSoundExString Space(<nCount>)->cSpaces SQrt(<nNumber>)->nRoot Standard()->cNull StoD([<cDate>])->dDate StoT([<cDateTime>])->dDateTime Str(<nNumber>,[<nLength>],[<nDecimals>],[lTrim])->cNumber ...

... SoundEx(<cString>)->cSoundExString Space(<nCount>)->cSpaces SQrt(<nNumber>)->nRoot Standard()->cNull StoD([<cDate>])->dDate StoT([<cDateTime>])->dDateTime Str(<nNumber>,[<nLength>],[<nDecimals>],[lTrim])->cNumber ...

... SetLastKey SetMode SetMouse SetNewDate SetNewTime SetPos SetPrc SetPrec SetRegistry SetTime ShowTime Sign Sin SinH SoundEx Space SQrt Standard StoD StoT Str StrDel StrDiff StrFile StrFormat StringToLiteral StrOccurs StrPeek StrPoke StrScreen StrSwap StrToHex StrTran StrZero Stuff SubStr SX_DtoP ...

... with both xHarbour and Harbour and has nothing to do with any SQL. d1 := {^ 2000/11/29 } // Assignment is done at compile time is same as d1 := STOD( "20001129" ) // Assignment is done at runtime and so, slower Please never use CTOD(..) because this depends on date format set, which ...

I just found that the following FWH modules do include hbcompat.ch: database.prgvaltostr.prg EMG I test xharbour->\xhb10162_con\xharbour\contrib\MySQL folder, TMySQL.prg not include hbcompat.ch so when make EXE, appear Error message .... 'HB_STOD' , ' HB_SYMBOL_UNUSED' add hpcompat.ch include an...

Antonio,

In ADO_GETVALUE there is a function hb_stod I dont know why!

Should I use stod

Antonio,

Thanks its solved.

I need this hb_SToD() What does it do and were can I find it?

Can you post the source?