[Openroad-users] WindowsAPI call to GetLocalTime

[Darren Harvey]

Bill

 

I'm responding on behalf of Jade.  The problem relates back to the chain of
e-mails titled 'eClient & Timezones'.

 

Running an eClient app at sites across multiple Timezones, we need to be
able to get the Current Local time regardless of what Timezone they are in.
So the App may be hosted in 'AUSTRALIA-NSW' and the time there may be 11:00.
If a user in Western Australia runs the application at 9:00 WA time, they
see '11:00am', but this is not what we want.  So what we are trying to
achieve is for the eClient app to pick up the Current local time off the PC.


 

Thanks

 

Darren

 

 

Regards

 

Darren Harvey

 



 

MyWorkplace Solutions Pty Limited

Level 5, 11 Queens Road

Melbourne Victoria 3004

 

Ph.       1300 733 731

Mob.     0400 398 188

Fax.      03 9710 1112

 

Making Service our Priority

 

www.MyWorkplace.com.au

 

If you receive this email by mistake, please notify us and do not make any
use of the email. We do not waive any privilege, confidentiality or
copyright associated with it.

 

  _____  

From: openroad-users-bounces at peerlessit.com
[mailto:openroad-users-bounces at peerlessit.com] On Behalf Of Bill Allan
Sent: Monday, 21 April 2008 7:10 PM
To: International OpenROAD Users; OpenRoad Users Group
Subject: Re: [Openroad-users] WindowsAPI call to GetLocalTime

 

Can I ask a stupid question?

 

Why do you need to use 'GetLocalTime'?   Ingres DATE_GMT(DATE('now')) will
give you a GMT ( UTC) string that can be cut up and give you all the
information apart from the Milliseconds component.

 

In Ingres 2006 there is a new ANSI DATE data type which has a number of good
features.  Here is part of the doco:

 

TIME WITH TIME ZONE hh:mm:ss.ffff... [+|-]th:tm 12:45:12.23456 -05:00

TIME or TIME WITHOUT TIME ZONE hh:mm:ss.ffff... 12:45:12.23456

other formats are:

ANSIDATE

TIME WITH LOCAL TIME ZONE 

TIMESTAMP WITH TIME ZONE 

TIMESTAMP or TIMESTAMP WITHOUT TIME ZONE

TIMESTAMP WITH LOCAL TIME ZONE

INTERVAL YEAR TO MONTH

INTERVAL DAY TO SECOND

Having the Timezone with ANSI DATE just tells you what the offset from GMT
isat that instant. It doesn't tell you the timezone name.

Bill Allan.

----- Original Message ----- 

From: jade clements <mailto:jade.clements at myworkplace.com.au>  

To: OpenRoad Users Group <mailto:openroad-users at sealion.peerlessit.com>  

Sent: Monday, April 21, 2008 12:18 PM

Subject: [Openroad-users] WindowsAPI call to GetLocalTime

 

Hello,

 

I'm using a Window's API call, GetLocalTime, to obtain the user's pc time
however I'm getting some weird results.

 

procedure zGetTime ( ) =

declare

    wYear = INTEGER NOT NULL;

    wMonth = INTEGER NOT NULL;

    wDayOfWeek = INTEGER NOT NULL;

    wDay = INTEGER NOT NULL;

    wHour = INTEGER NOT NULL;

    wMinute = INTEGER NOT NULL;

    wSecond = INTEGER NOT NULL;

    wMilliseconds = INTEGER NOT NULL;

 

enddeclare

{

    CALLPROC GetLocalTime(

        byref(wYear), 

        byref(wMonth), 

        byref(wDayOfWeek), 

        byref(wDay), 

        byref(wHour), 

        byref(wMinute), 

        byref(wSecond), 

        byref(wMilliseconds));

 

CurProcedure.TRACE(

    'Year: ' + VARCHAR(wYear) + 

    ' Mth: ' + VARCHAR(wMonth) + 

    ' Day: ' + VARCHAR(wDay) + 

    ' Hr: ' + VARCHAR(wHour) + 

    ' Min: ' + VARCHAR(wMinute) + 

    ' Sec: ' + VARCHAR(wSecond) + 

    ' DOW: ' + VARCHAR(wDayOfWeek)); 

}

 

 

Result:

Year: 264152 Mth: 1376257 Day: 45023240 Hr: 0 Min: 0 Sec: 0 DOW: 917516

 

The Day value changes everytime the procedure is run.

 

The API guide mentions that the GetSystemTime function returns the system
time expressed in Coordinated Universal Time (UTC).  I guess the same goes
for GetLocalTime however, the return values just aren't right.

 

 

Can anyone help?

 

 

 

Regards

Jade Clements

 



 

MyWorkplace Solutions Pty Limited

Level 5, 11 Queens Road

Melbourne Victoria 3004

 

 

Ph:  1300 733 731

Making Service our Priority

 

www.MyWorkplace.com.au

 

If you receive this email by mistake, please notify us and do not make any
use of the email. We do not waive any privilege, confidentiality or
copyright associated with it.

 

 


  _____  


________________________________________________________________
OpenROAD-Users mailing list

You can maintain your subscription here:
http://www.peerlessit.com/mailman/listinfo/openroad-users

To unsubscribe click on this link
mailto:openroad-users-unsubscribe at peerlessit.com&subject=unsubscribe

To subscribe click on this link
mailto:openroad-users-subscribe at peerlessit.com&subject=subscribe

-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://www.peerlessit.com/pipermail/openroad-users/attachments/20080422/ff231df9/attachment.html 
-------------- next part --------------
A non-text attachment was scrubbed...
Name: not available
Type: image/jpeg
Size: 1436 bytes
Desc: not available
Url : http://www.peerlessit.com/pipermail/openroad-users/attachments/20080422/ff231df9/attachment.jpe