FiveTech Software tech support forums

... 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 large tables ...

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

... FW_DateToUnix( MyDate ) //168486480000  But in https://www.timestamp-converter.com/ , I'm having a different result(as you can view bellow). Do you know why ? https://i.imgur.com/uvNARPC.jpg

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( <c> )   #xtranslate HB_DateTime()  ...

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?

... 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 expressed in milliseconds, ...

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

... operation and we like to transfer from local to remote only those records inserted or modified recently, the process can be optimized if we have a timestamp fields which is updated with every insertion and modification. In such a case, we can simply use this method and do the entire operation with ...

... as follows. I open the database with EmagDbu238 while the MsgInfo is displayed. Then I see that "test" is in the database, although the timestamp of the file has not changed. Without the use of UNLOCK, it does not work. Exactly as Mr. Rao writes. Constantly committing stresses the hard ...

Hello everyone, I have a problem creating a signature to validate my identity in an oath 1.0 system y have this credentials oauth_consumer_key="8pr53tcagfih9bpvo24m1t8z9xd42tx3", oauth_nonce="W6ndLpigOjP025vmvGSJdqEEylRUusgg", oauth_signature_method="HMAC-SHA256", oauth...