FiveTech Software tech support forums

... ifndef __HB_MAIN__
#define __HB_MAIN__ AppMain /* Or whatever you wish to call it */
#endif
FUNCTION __HB_MAIN__()

2003-08-02 12:00 UTC+0200 Przemyslaw Czerpak <druzus@polbox.com>
* xharbour/make_tgz.sh
* xharbour/xharbour.spec
* xharbour/source/vm/hvm.c
* small modification in ...

... ifndef __HB_MAIN__
#define __HB_MAIN__ AppMain /* Or whatever you wish to call it */
#endif
FUNCTION __HB_MAIN__()

2003-08-02 12:00 UTC+0200 Przemyslaw Czerpak <druzus@polbox.com>
* xharbour/make_tgz.sh
* xharbour/xharbour.spec
* xharbour/source/vm/hvm.c
* small modification in ...

... in any order (something not possible with Alexander's lib)

It is possible too, using an extra parameter when building library.

2021-10-31 04:50 UTC-0300 Jose Quintas
! source/winapi/hdialog.prg
! source/winapi/hwindow.prg
! Small change for multithread
Each thread will have it's own dialog ...

FWH function UTC_TIMESTAMP() is based on Harbour function HB_TStoUTC( tDateTime )
The Harbour functions HB_UTCOFFSET() and HB_TSTOUTC() work correctly if the Windows Settings of timezone are correct.

Taavi wrote:Hello,
seems that utc_timestamp() is giving me -2 hours from my local time (east european summer time) while correct would be -3 hours.

Can it be fixed? Or any workarounds?

https://www.timestamp-converter.com/

Taavi

Nages made a fwh function please search on my oldest topic

Good morning. Have you SYNCED your WINDOWS clock? See the TAB: INTERNET TIMETABLE.

Buen día. ¿Has SINCRONIZADO tu reloj de WINDOWS? Ver la PESTAÑA: HORARIOS DE INTERNET.

https://support.microsoft.com/pt-br/windows/como-definir-a-hora-e-o-fuso-hor%C3%A1rio-dfaa7122-479f-5b98-2a7b-fa0b6e01b261 ...

Hello,
seems that utc_timestamp() is giving me -2 hours from my local time (east european summer time) while correct would be -3 hours.

Can it be fixed? Or any workarounds?

https://www.timestamp-converter.com/

Taavi

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

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() // current time
tDateTimeUTC := UTC_TIMESTAMP( tDateTimeLocal ...

Both are same.
In that website there is an implicit conversion from your time zone to UTC.
Try this code: Note: UTC_TIMESTAMP() is an FWH function

... with Seconds.

Examples:
? oCn:QueryResult( "SELECT UNIX_TIMESTAMP( ? )", { HB_DateTime() } )
? oCn:QueryResult( "SELECT FROM_UNIXTIME( ? , '%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.

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- -w-ccc- -w-csu- -w-par- -w-rch- -w-ucp- -w-use- -w ...

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 users who want
to compile Harbour should delete harbour ...