Attached is an extract function interval for dayname - with which you can extract(dayname from datefield) and return the english name for day of the week.
This is not part of the typical interval set within MySQL for instance - but seems useful nonetheless. enjoy. -Larry > -----Original Message----- > From: Paul Hammant [mailto:[EMAIL PROTECTED]] > Sent: Friday, January 04, 2002 5:06 PM > To: MCCAY,LARRY (HP-NewJersey,ex2) > Subject: Re: [DB] Tasks for newbies > > > Larry, > > >Attached are some extract function interval implementations: > >daysecond, hourminute, hoursecond, minutesecond, yearmonth > > > >I hope that they are appropriate implementations - I added an > >AbstractTemporalStringFunction to extend them from. If this > is not inline > >with expectations - just kick it back to me. > > > No they are fine. I fixed the imports. Too many in some > cases, and .* > (a jakarta no-no) in others. > > >I have added them to the SelectColumnHelper and attached my > version of that > >as well. > > > >I have also created a test3.script for testing these - just > in case they are > >not ready to be merged into test2.script. > > > Indeed. I have even reverse engineered (not hard) the new > build.xml file. > > SelectColumnHelper had some legacies of CVS's merge in it. > I've trimmed > those too. I so much prefer proper revision control systems like > 'Perforce'. > > Keep up the good work. Do you fancy taking on one of the alternate > parsers. We want to have one that writes Java source and > invokes javac* > to copile it. It would be slower for CreateTable and first > invocations > of SimpleSelect, but much faster on susequent runs (which im my > experience amount to 99.999% of all traffic). > > * There was a Cocoon module I wanted to migrate to Excalibur > that wraps > com.sun.tools.Javac, but we have problems in that in JDK1.4 javac has > lost its public access. It was static anyway and main(..) is a an > antipattern IMHO. Luckily jikes is still lanchable by the > Cocoon class. > > Clearly, unless it you balk at the prospect we'll also need committer > access for you. Given the Meritocracy nature of this place, > it should > not be hard. Also, it is always proposed for a vote by an existing > committer and never asked for by the recipient (a mistake I > made a year > and a bit ago). > > Regards, > > - Paul H >
DayNameTemporalFunction.java
Description: Binary data
SelectColumnHelper.java
Description: Binary data
-- To unsubscribe, e-mail: <mailto:[EMAIL PROTECTED]> For additional commands, e-mail: <mailto:[EMAIL PROTECTED]>
