FiveTech Software tech support forums

... , '%d-%m-%Y %H:%i:%S')", { nUnixTimeInSeconds} ) Also while dealing with TimeStamps in MySql, we need to keep in mind automatic TimeZone conversions from UTC.

... to our local time zone, at the very beginning. with SET @@session.time_zone = '-03:00';  and then proceed. Note: '-03:00' is Brazil TimeZone (UTC-3). If I am still not clear, please let me know.

... para recuperar todas las carpetas (directorios) y ficheros de una determinada carpeta. * Nueva función: function FW_TIMEZONE( [lNegative] ) --> Timezone en formato +/-HH:MM. Si el parámeto opcional lNegative es puesto a .T., se cambia de signo. * Nueva función: function cRelativePath( cFullPath, ...

... samples\elixir.prg and elixir.rc, shows how to use a TreeView to review all folders and files. * New: function FW_TIMEZONE( [lNegative] ) --> Timezone in format +/-HH:MM. If the optional parameter lNegative is .t., the sign is reversed. * New: function cRelativePath( cFullPath, [cCurrentPath] ...

... mins 15 secs Error occurred at: 12/06/2018, 09:06:25 Error description: Error BASE/1132 Bound error: array access Args: [ 1] = H {=>} [ 2] = C timeZone Stack Calls =========== Called from: .\source\internal\TGEVECAL.PRG => TGEVENTCALC:HASHLISTEVENTS( 399 ) Called from: .\source\internal\TGEVECAL.PRG ...

... Fixed See http://forums.fivetechsupport.com/viewtopic.php?f=3&t=33179 * FWHMARIADB: - Now works with GCC also - At time of connection, session timezone is set to local time of zone of the PC connecting to the server. This resolves many possible issues with consistency of timestamp values internationally ...

Here is another approach, utilizing (x)Harbour's capabilities of datetime computations and also incorporating the timezone conversion implications. function MyConvert( cUnixName )return cFileSetExt( Left( TTOS( STOT( "19700101000000" ) + Val( ...

Here is another approach, utilizing (x)Harbour's capabilities of datetime computations and also incorporating the timezone conversion implications. function MyConvert( cUnixName )return cFileSetExt( Left( TTOS( STOT( "19700101000000" ) + Val( ...

Many thanks
but I do not explay very wel the problem

This is the string to convert "1458480306"

Unix time, the number of seconds since 00:00:00 UTC on January 1, 1970

into this 20160320142506
or simply into

Date in your timezone*: 20/3/2016, 14:25:06

mucias gracias

... tengo problemas...saludos... :shock: [phpBB Debug] PHP Notice: in file /viewtopic.php on line 943: date(): It is not safe to rely on the system's timezone settings. You are *required* to use the date.timezone setting or the date_default_timezone_set() function. In case you used any of those methods ...

... this evening. The complete messages [phpBB Debug] PHP Notice: in file /viewtopic.php on line 943: date(): It is not safe to rely on the system's timezone settings. You are *required* to use the date.timezone setting or the date_default_timezone_set() function. In case you used any of those methods ...

... "longitude": "13.729030" } }, "areaRank": "1", "popRank": "10", "timezone": { "type": "Fuso Orario", "woeid": "28350914", "content": "Europe/Rome" } ...

... engine selected language. * Enhancement: optional parameter nHelpID supported by function MemoEdit(), thanks to Dan Landon * Enhancement: function TimeZone() adjusts Bias for daylight savings time, thanks to Dan Landon * Fix: tabs.prg. Destroy() method was trying to release oFont twice. Fixed. ...

Javier, suponiendo que los usuarios tienen internet, puedes usar Webservice:

http://www.earthtools.org/webservices.htm#timezone

Si tu no sabes como usarlo, talvez otro compañero podría indicar como usarlo, ya que yo no sé...
Sería muy util para todos...

Hi James,

thank you, I'm going to do it, however I've already found the solution by EMG at viewtopic.php?f=3&t=15550&hilit=utc+time (standard TimeZone() function erroneously retrieves 1 instead of 2 in my system)

Thanks,
Davide