Login ProductsSalesSupportDownloadsAbout |
Home » Technical Support » DBISAM Technical Support » Support Forums » DBISAM General » View Thread |
Messages 1 to 4 of 4 total |
first and lastdate |
Sun, Apr 22 2007 9:36 AM | Permanent Link |
"Harry de Boer" | dbIsam 3.3.
How do I get (SQL) (from all the records in a table) the first and the last date (datefield). E.g 2006-01-31 2006-01-03 2006-06-24 2006-06-07 gives firstdate 2006-01-03 lastdate 2006-06-24 Regards, Harry |
Sun, Apr 22 2007 9:58 AM | Permanent Link |
Roy Lambert NLH Associates Team Elevate | Harry
select Min(_Date) AS Earliest, Max(_Date) AS Latest FRom SpamStats Roy Lambert |
Sun, Apr 22 2007 12:44 PM | Permanent Link |
"Harry de Boer" | Roy, Thanks! If everything was as simple as that
"Roy Lambert" <roy.lambert@skynet.co.uk> schreef in bericht news:3E12F4B8-3516-403C-9DAD-96DE1331FF9A@news.elevatesoft.com... > Harry > > > select Min(_Date) AS Earliest, Max(_Date) AS Latest FRom SpamStats > > Roy Lambert > |
Sun, Apr 22 2007 1:15 PM | Permanent Link |
Roy Lambert NLH Associates Team Elevate | Harry
>Roy, Thanks! If everything was as simple as that It usually is ...... afterwards Roy Lambert |
This web page was last updated on Friday, March 29, 2024 at 03:30 AM | Privacy PolicySite Map © 2024 Elevate Software, Inc. All Rights Reserved Questions or comments ? E-mail us at info@elevatesoft.com |