Server time vs local time - use of

Xojo Cloud
1

Hello, I use a time stamp in my database to record a customer transaction. I notice the time stamp being saved is quite different from my local time here in New Zealand. Obviously the App is working on the servers which will have a different time from my local. I thought the Sydney server was in Sydney though in which case
it should only be three hours behind but this is not the case, which is a mystery ? It would be much better if I could save a time stamp which was the actual
local time and save confusion for the users of my app.
Is there a good way to do this in Xojo ? Alternatively where is the Sydney server getting it’s time from so I can perhaps
use a bit of code to convert to NZ local time and then save it. I read in a previous thread that it was not a good idea to use server time for customer transaction records… does anyone know why that might be ? Thanks.

2

I create a time stamp for a visitor check in and check out on a guest book system. I create the timestamp locally and store in a date time field, as opposed to a timestamp field which gives me a consistent time.

3

servers are probably running in UTC

4

Right. Thanks for that.

5

On the command prompt will give you the current time of server

timedatectl

Local time: Sun 2015-11-22 21:20:30 EST Universal time: Mon 2015-11-23 02:20:30 UTC RTC time: Mon 2015-11-23 02:20:30 Time zone: America/New_York (EST, -0500) NTP enabled: no NTP synchronized: no RTC in local TZ: no DST active: no Last DST change: DST ended at Sun 2015-11-01 01:59:59 EDT Sun 2015-11-01 01:00:00 EST Next DST change: DST begins (the clock jumps one hour forward) at Sun 2016-03-13 01:59:59 EST Sun 2016-03-13 03:00:00 EDT
to change the current time

timedatectl set-time YYYY-MM-DD Or sudo timedatectl set-time YYYY-MM-DD
To see list all available time zones, enter

timedatectl list-timezones | more

To set the time zone.

timedatectl set-timezone 'country'

I don’t know if the xojo cloud have terminal access but give a try.

6

[quote=273148:@Loannis Kolliageorgas]On the command prompt will give you the current time of server

timedatectl

Local time: Sun 2015-11-22 21:20:30 EST Universal time: Mon 2015-11-23 02:20:30 UTC RTC time: Mon 2015-11-23 02:20:30 Time zone: America/New_York (EST, -0500) NTP enabled: no NTP synchronized: no RTC in local TZ: no DST active: no Last DST change: DST ended at Sun 2015-11-01 01:59:59 EDT Sun 2015-11-01 01:00:00 EST Next DST change: DST begins (the clock jumps one hour forward) at Sun 2016-03-13 01:59:59 EST Sun 2016-03-13 03:00:00 EDT
to change the current time

timedatectl set-time YYYY-MM-DD Or sudo timedatectl set-time YYYY-MM-DD
To see list all available time zones, enter

timedatectl list-timezones | more

To set the time zone.

timedatectl set-timezone 'country'

I don’t know if the xojo cloud have terminal access but give a try.[/quote]
There’s no shell access on Xojo Cloud.