Re: CURRENT does not work!

> alastl@ix.netcom.com (John Prideaux) writes: > In <3t4n5u$1ndi@news.gate.net> stevie@gate.net writes: > > > >I am running 7.1 online on SCO ODT 3.2v4.2, and am experiencing an > >interesting problem. When I assign "CURRENT" to a variable, the > display > >its contents, I get "0000-00-00 00:00:00". Today and time work just > fine. > > > I've got the same problem, but I had so many other problems during my > recent upgrade (5 official bug numbers) that I forgot about it. I need > to call Informix. > > In the mean time, I found a work around in those crazy first hours > after our upgrade: SELECT CURRENT FROM SYSTABLES WHERE TABNAME = > "systables". > I know it is a horrible hack, but performance is good, and it returns > the proper result. > > John Prideaux > alastl@ix.netcom.com > >>>> You are correct - it works! And, you are also correct about this being a horrible hack! Someone mailed me another solution. define dte_var datetime year to second str_var char(19) let str_var = date using "yyyy-mm-dd", time let dte_var = str_var Thanks again, Steve