FiveTech Software tech support forums

... en harbour, aparentemente es un cambio inicuo que no debería provocar el error que experimentas, pero del dicho al hecho... 2024-02-09 20:56 UTC+0100 Przemyslaw Czerpak (druzus/at/poczta.onet.pl) ... ... * src/rdd/dbcmd.c + accept symbol items in Select() and DbSelectArea() just like in ( ...

... en harbour, aparentemente es un cambio inicuo que no debería provocar el error que experimentas, pero del dicho al hecho... 2024-02-09 20:56 UTC+0100 Przemyslaw Czerpak (druzus/at/poczta.onet.pl) ... ... * src/rdd/dbcmd.c + accept symbol items in Select() and DbSelectArea() just like in ( ...

Converting time in Spain to my local time in India.
We know the current UTC offset of Spain is +1:00 and India's is +5:30

Code: Select all  Expand view

tsUTC := FW_AddTime( DateTimeSpain. "-01:00:00" )
tsIndia := FW_AddTime( tsUTC, "05:30:00" )

Time Zone conversions Here is an example converting our local time to UTC and then NewYork time ( UTC Offset now -5:00 ) function TimeZoneConversions()   local tDateTimeLocal, tDateTimeUTC, tDateTimeNYC   tDateTimeLocal := HB_DateTime()  // ...

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

... { nUnixTimeInSeconds} ) Also while dealing with TimeStamps in MySql, we need to keep in mind automatic TimeZone conversions from UTC.

A partir del ultimo commit de harbour 2023-11-22 09:06 UTC+0100 Przemyslaw Czerpak (druzus/at/poczta.onet.pl) He intentado construir harbour con BCC77 y da el siguiente error bcc32.exe   -I. -I../../../../../../include -q -tWM -CP437 -w-sig- -w-aus- ...

Reference: 2012-09-11 21:22 UTC+0200 Przemyslaw Czerpak (druzus/at/poczta.onet.pl) * harbour/utils/hbmk2/hbmk2.prg * harbour/config/win/bcc.mk + added support for BCC6.5 - please verify me. ; unicows library does not support BCC 6.5. BCC ...

... "19700101000000" ) + ( nUnixDate / 24.0 / 3600.0 ) This returns the harbor DateTime value. Testing from India: present UTC nUnixTime is 1683872102 ? tUTC := UnixToDateTime( nUnixTime ) // 12-05-2023 06:15:02 ? tLocal := FW_UTCTOLOCAL( tUtc ) // 12-05-2023 11:45:02 Compare ...

... "19700101000000" ) + ( nUnixDate / 24.0 / 3600.0 ) This returns the harbor DateTime value. Testing from India: present UTC nUnixTime is 1683872102 ? tUTC := UnixToDateTime( nUnixTime ) // 12-05-2023 06:15:02 ? tLocal := FW_UTCTOLOCAL( tUtc ) // 12-05-2023 11:45:02 Compare ...

Silvio, you can use another STRTRAN. cText := StrTran(cText, '"', '' ) Regards, Otto aShow := {}                cText    := MEMOREAD( cFile)                                cText    := ALLTRIM( cText )                cText    := StrTran( cText, CRLF,  ","...

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

hi, did you use ORDER BY mytimestamp when "compare" TIMESTAMP :?: as i know ORDER BY use UTC but you want "Local Time" so try ORDER BY CAST(mytimestamp AS datetime) It is not necessary to ORDER BY THE field for setting WHERE clause on that field. ...

hi, did you use ORDER BY mytimestamp when "compare" TIMESTAMP :?: as i know ORDER BY use UTC but you want "Local Time" so try ORDER BY CAST(mytimestamp AS datetime) It is not necessary to ORDER BY THE field for setting WHERE clause on that field. ...

hi,

did you use

Code: Select all  Expand view

ORDER BY mytimestamp

when "compare" TIMESTAMP

as i know ORDER BY use UTC but you want "Local Time" so try

Code: Select all  Expand view

ORDER BY CAST(mytimestamp AS datetime)