Re: New Era & Current Datetime

On 4 Nov 1997, P Bent wrote: > I was kind of expecting the CURRENT function into a DATETIME to return the > Server's current time. > > I am unfortunately getting the local PC's time. Which wreaks havoc... > > Any ideas how I can do it without using a stored procedure? Execute the equivalent of: SELECT CURRENT FROM 'informix'.SysTables WHERE Tabid = 1 retrieving the result into a convenient datetime variable? Yours, Jonathan Leffler (johnl@informix.com) #include <witticism.h>