FiveTech Support Forums

FiveWin / Harbour / xBase community
Board index FiveWin for Harbour/xHarbour utc_timestamp() function problem
Posts: 97
Joined: Mon Nov 21, 2005 10:29 AM

utc_timestamp() function problem

Posted: Wed Jul 31, 2024 12:54 PM
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
Posts: 8523
Joined: Tue Dec 20, 2005 07:36 PM

Re: utc_timestamp() function problem

Posted: Wed Jul 31, 2024 01:38 PM
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#:~:text=Em%20Data%20%26%20hora%2C%20voc%C3%AA%20pode,%26%20idioma%20%3E%20Data%20%26%20hora.

Regards, saludos.
João Santos - São Paulo - Brasil - Phone: +55(11)95150-7341
Posts: 7318
Joined: Thu Oct 18, 2012 07:17 PM

Re: utc_timestamp() function problem

Posted: Wed Jul 31, 2024 03:42 PM
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
Since from 1991/1992 ( fw for clipper Rel. 14.4 - Momos)

I use : FiveWin for Harbour March-April 2024 - Harbour 3.2.0dev (harbour_bcc770_32_20240309) - Bcc7.70 - xMate ver. 1.15.3 - PellesC - mail: silvio[dot]falconi[at]gmail[dot]com
Posts: 10733
Joined: Sun Nov 19, 2006 05:22 AM

Re: utc_timestamp() function problem

Posted: Wed Jul 31, 2024 03:56 PM

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.

Regards



G. N. Rao.

Hyderabad, India

Continue the discussion