For Jonathan - or connect seems to be toasted again

---------------------------------------------------------- (FYI) ----- Transcript of session follows ----- 421 rent2.informix.com (tcp)... Deferred: No route to host <johnl@rent2.informix.com>... Deferred: No route to host ---------------------------------------------------------- > > >That is not very nice. > > You're not going to like it. Not at all... > > But (with DBDATE=dmy4/), these are all accepted: > > SELECT * FROM Table > WHERE Datetime_fld > EXTEND(DATE("05/05/1993"), YEAR TO SECOND);> > SELECT * FROM TABLE > WHERE Datetime_fld > DATETIME(1993-08-31 00:00:00) YEAR TO SECOND;> > SELECT * FROM TABLE > WHERE Datetime_fld > EXTEND(DATETIME(1993-05-05) YEAR TO DAY, YEAR TO SECOND);> > Oh well! > > Yours, > Jonathan Leffler (johnl@informix.com) #include <disclaimer.h> > I figured this and have opted, in the next table where they are required, to keep date in a date field and time in a datetime field. I could not get the first statement to work. I fear that I don't understand the third. Does this mean that the DATETIME (1993-05-05) is a year to day which is then EXTENDED to YEAR TO SECOND - must be jack? How to I get this to work from the form into a construct forming a legible where statement. Also - is it just me or do ":" and "|" not work - when I try them I get a fatal error. cheers j. _____________________________________________________________________________ Jack Parker | "In fact in matters animal or Hewlett Packard, BSMC Boise, Idaho, USA| vegetable or mineral I am the jparker@hpbs2561.boi.hp.com | very model of a (208) 396-5388 (W) (208) 384-1623 (H) | modern major general." _____________________________________________________________________________ Any opinions expressed herein are my own and not those of my employers. _____________________________________________________________________________