[Openroad-users] WindowsAPI call to GetLocalTime

[Fabian Anderson]

Hi Bill,

            The main reason (for me) was so that the time-zone info
could come from the client environment and not the server.

 

I think the requirement called for a time with time-zone applied, but
the problem was that it needed to have the correct time-zone applied.

 

Regards,

Fabian.

 

 

________________________________

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


______________________________________________________________________
This email has been scanned by the MessageLabs Email Security System.
For more information please visit http://www.messagelabs.com/email 
______________________________________________________________________


Specialist providers of back and front office systems for the financial services industry.
Featuring:  Fintechnix(r)
Disclaimer: 
Notice: This message contains privileged and confidential information intended only for the use of the addressee named above. If you are not the intended recipient of this message you are hereby notified that you must not disseminate, copy or take any action in reliance on it.
Any views expressed in this message are those of the individual sender,except where the sender specifically states them to be the views of Fintechnix Pty Ltd.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://www.peerlessit.com/pipermail/openroad-users/attachments/20080422/a4853046/attachment-0002.html 
-------------- next part --------------
A non-text attachment was scrubbed...
Name: not available
Type: image/jpeg
Size: 1436 bytes
Desc: image001.jpg
Url : http://www.peerlessit.com/pipermail/openroad-users/attachments/20080422/a4853046/attachment-0002.jpe