Re: Umm, almost embarrassed to ask this, but....

Neil Truby wrote in article <6bmth0$k38@drn.zippo.com>... > In article <aEA3aIAtTg30Ewzp@smooth1.demon.co.uk>, David says... > > > > Why do you need to select it. Most languages have a way of getting > > the value. E.g. 4GL has the TODAY keyword. > > > But if you're just writing straight SQL via dbaccess.....? > > Neil > I usually use: select today -- or "current", or "user", etc. from systables where tabid = 1 You might want to do this even from a 4GL, ESQL, or other program if you're in a client server enviornment. That way all clients will get the same time (i.e. from the server). HTH -- Irwin Goldstein Objective Software Systems, Inc. http://www.objectsoft.com Remove anti-spam characters from e-mail address when responding.