Currently when I use @Time function, it gives me value in 24 hour clock. e.g.  14.52.  How can I get value with the seconds using @Time, that is current time?  e.g. 14:52:36 CST

Hallo!
you can use @servertime() function.

I need to have time converted to GMT. The problem is our time changes in fall and spring. Is there an easy solution for this?

Bharat_Naik wrote on Sep 28^th, 2011 at 7:44pm:


Windows, unfortunately, does not seem to have a single command for this purpose (Unix does). But you can derive the information from the systeminfo command:

var aa as string
var bb as int

aa = @RedirectProcess("systeminfo", "")
bb = @InStr(aa, "GMT")
aa = @Mid(aa, bb + 3, 6)
writeln(aa)

 

This should tell you how many hours off (positive or negative) you are from GMT. I am in EDT and I get "-05:00". So if I add five hours to my current time, I get GMT. Be forewarned, because it is used for a few dozen other purposes, the "systeminfo" command isn't about to break any speed records.

It is good that now I will not have to prepare the following table. Since the dates for change of time is not constant and again the time changes at 2.00am and date changes forward if the time goes over 24.00 hour, it would have been quite daunting to take everything into account.

Calendar Year      DST Starts/Begins      DST Stops/Ends
2009      March 8      November 1
2010      March 14      November 7
2011      March 13      November 6
2012      March 11      November 4
2013      March 10      November 3
2014      March 9      November 2
2015      March 8      November 1
2016      March 13      November 6

Thanks Mark for the solution.