FiveTech Software tech support forums

Thank you, now it's working perfectly

Both are same.
In that website there is an implicit conversion from your time zone to UTC.
Try this code:

Code: Select all  Expand view

? FW_DateToUnix( UTC_TIMESTAMP() )

Note: UTC_TIMESTAMP() is an FWH function

Thank you Mr Rao, If I try with your function, I'm having this result: 168486480000 for 2023-05-23T18:00:00 SET DATE BRITmyDate := Hb_Dtot(Ctod("23/05/2023"),"18:00:00")? FW_DateToUnix( MyDate ) //168486480000  But in https://www.timestamp-converte...

Hi Guys, How could I convert a date/time to an Unix TimeStamp? If you want to use this functionality with MySql, you can use the MySql built-in functions UNIX_TIMESTAMP( <datetime> ) FROM_UNIXTIM( nUnixTime ) Please note that ...

* New functions: (valtostr.prg) FW_DateToUnix( dDate/tDateTime ) --> nUnixTimeStamp in MilliSeconds FW_UnixToDate( nUnixTimeStamp(inMilliSeconds) ) --> tDateTime #ifdef __XHARBOUR__   #xtranslate HB_STOT( <c> ) => STOT( ...

We have already implemented those functions for FWH already

Please lets wait for Mr. Rao comments about them

Ruth,
I tried it, but didn´t work here. IF you compare the result with that generated from https://www.timestamp-converter.com/, they aren´t the same.

...maybe this ist what you are looking for?
https://forums.fivetechsupport.com/viewtopic.php?f=3&t=44151&sid=b7f00a693917947fa556918b1485830b
kind regards
ruth

Hi Guys,

How could I convert a date/time to an Unix TimeStamp?

... 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 expressed in milliseconds, you need to follow these steps: Get the date value from ...

... 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 departure ...

Once we know that 1970-01-01 is the epoch date in Unix, it is very easy to write the conversion: function UnixToDateTime( nUnixDate )return HB_STOT( "19700101000000" ) + ( nUnixDate / 24.0 / 3600.0 ) This returns ...

Once we know that 1970-01-01 is the epoch date in Unix, it is very easy to write the conversion: function UnixToDateTime( nUnixDate )return HB_STOT( "19700101000000" ) + ( nUnixDate / 24.0 / 3600.0 ) This returns ...

... converte a number -> time_next_update_unix https://i.postimg.cc/gkMnfYQt/tt.png I found this function but not run ok FUNCTION UnixToDate(nUnix)   LOCAL nSecs, dDate, cTime, dDateTime       nSecs := nUnix - 28800 // correzione fuso orario   dDate := CTOD("01/01/1970")  ...

Estoy apenas entrando en el mundo Harbour y FiveWin, por motivos de modificar el software que la empresa tiene. Y en otras partes uso UNIXTIME por lo que me toco realizar este código ya que no conseguí en linea otra forma: Function getUnix2(dDate,tTime)  Local nYearI  := hb_ctot("19...