I agree with Gauthier, storing dates/times as seconds makes life so much simpler.
-----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of [Gauthier] Sent: Tuesday, May 07, 2002 12:40 PM To: Multiple recipients of list witango-talk Subject: Re: Witango-Talk: Sort by date For my case I only use seconds timestamp, so you can order it as any numeric column. Could you give us an example of what your date column look like? if you want to do the same thing from another date format look at <@TSTOSECS> (for processing date sorting) and <@SECSTOTS> (for display purpose) Gauthier ----- Original Message ----- From: "Prasad Ramalingam" <[EMAIL PROTECTED]> To: "Multiple recipients of list witango-talk" <[EMAIL PROTECTED]> Sent: Tuesday, May 07, 2002 5:42 PM Subject: Witango-Talk: Sort by date > hi everyone! > can anyone help me in sorting an array which contains date values.I > remember this question being asked before and forgot the solution.I went and > searched the archives in Witango and found only this which was of little > help. > I am afraid if there exist any solution for sorting a date column in an > array using the <@SORT > command through some technique. > If any other technique which is quick enough its most welcome. > > The problem that I have is that I have few other cols like names and > numerics which is also to be sorted based on the clients action. > > thanx > Prasad R > Tango Lead > OfficeTiger Database Systems India Pvt. Ltd. > mailto:[EMAIL PROTECTED] > http://www.officetiger.com > > > > ########################################################################## > Author: Mailing List Subscriptions > Posted: 14/08/1999 12:25:27 AM > Yesterday, I mentioned that the only problem with @MAP is that it > ONLY RETURNS A ONE COLUMN ARRAY (vs. updating a desired column in an > array). > > Depending upon record size and the likely number to be returned in a > given foundset, we often put the resultSet into an Array and serve > run the summary list functions from it. This provides all sorts of > advantages. > > One of the biggest is providing clickable column headers to sort > ascending/descending. Since the sort is done in RAM, it's lightening > fast. > > HOWEVER, @SORT still doesn't accommodate dates nor times (was really > hoping for Tango 3.6) which is a real drag since many lists include > dates. > > This is one area we have very little luck coming up with a realistic > work around. > > @MAP would be great if one could assign an entire row or column at a time: > <@ASSIGN local$myArray[*,aDate] '<@MAP local$myArray > value="#aDate" true="<@DATETOSECS DATE=#aDate>">'> > > The above says to "Update" column "aDate" with aDate converted to > seconds, which would then sort numerically just fine. > > The other option would be to do an @ADDCOLS with the result of the > @MAP to add a new column with the seconds and sort by it. > Unfortunately, @ADDCOLS and @DELCOLS hasn't been seen as a priority > for the development team (maybe a bunch of emails to the product > manager would help?) > > Thus, we're stuck. > > Failing... > 1) @SORT supporting Dates > 2) @ASSIGN supporting rows/columns at a time > 3) @ADDCOLS, @DELCOLS support (this would be SO useful!) > > The only way I can think of to sort a date/time in an array is to do > a @ROWS loop and recreate the array. UGH! On arrays of any > significant size this is really slow and consumes memory. > > There's got to be a better way!?! > > __________________________________________ > Chris OgdenInfoMatters, Inc. > 441/236-8183 http://InfoMatters.com > Dynamic Website Design, Creation, Implementation, > Promotion, Maintenance, and Software > ############################################################################ > ###########3 > > ________________________________________________________________________ > TO UNSUBSCRIBE: send a plain text/US ASCII email to [EMAIL PROTECTED] > with unsubscribe witango-talk in the message body ____________________________________________________________________________ __ ifrance.com, l'email gratuit le plus complet de l'Internet ! vos emails depuis un navigateur, en POP3, sur Minitel, sur le WAP... http://www.ifrance.com/_reloc/email.emailif ________________________________________________________________________ TO UNSUBSCRIBE: send a plain text/US ASCII email to [EMAIL PROTECTED] with unsubscribe witango-talk in the message body ________________________________________________________________________ TO UNSUBSCRIBE: send a plain text/US ASCII email to [EMAIL PROTECTED] with unsubscribe witango-talk in the message body
