Re: Dates In Informix

> I'm new to Informix (been working with Oracle for the last couple of > years) and I can't seem to figure out how to get the last date/time > from a table in a subselect. I've tried the MAX function but no > luck. Is there a way to select the last date and time from a table? > What have I overlooked?? Well, if it's a DATETIME data type, SELECT MAX() should work. If you're using a DATE & and (say) a CHAR(5) for the time, you would have to SELECT MAX(date) and then SELECT MAX(char) for that date. HTH. -- Cheers, Billy ----------------------------------------------------------- e-ddress: billy.wheeler@pixie.co.za Work: +27 11 803 2151 Fax: +27 11 803 2189 Cell: +27 83 250 2324 GCM/CS d++(--) h--- s+:++ !g p?+ au++ a? w+ v++/* C+++ 3 k- UCLAVH++++ p+++ L++ E-- N++ W--- M" V-- -po+ y+ t+ !5 j++ R+ G? tv+ b+++ D+ B-- e+ u** h----(++) f+ r+++ !n z++++/** -----------------------------------------------------------