[Babase] Re: [Babaseannounce] New functions for hydrological year
and season
Susan Alberts
alberts at duke.edu
Fri Aug 27 12:07:09 EDT 2010
Thanks, I propose that we include these three function (hydroyear,
season and rnkdate) in the "SQL for Babase" document that is on our
wiki; chapter 3 is operations and functions, we can list these as
custom functions. Lacey, can you do that or does it make sense for
someone else ot? Or Karl is it already posted somewhere on the wiki?
Susan
On Aug 27, 2010, at 9:44 AM, Niki Learn wrote:
> We have two new functions available in babase for converting dates
> to hydrological year and season. They are as follows:
>
> hydroyear() Takes a date and returns the hydrological year.
> http://papio.biology.duke.edu/babase_system_html/re08.html
>
> season() Takes a date and returns a code for the season (wet/wetter
> vs. dry).
> http://papio.biology.duke.edu/babase_system_html/re09.html
>
> Thanks Catherine for suggesting and Karl for implementing!
>
> Another handy date function (an oldie but goodie) = rnkdate() Take
> a date and returns the first of the month (e.g., an agonism that
> took place on 2009-08-27 becomes 2009-08-01) – great for matching
> events within a month up by say the date on which an animal was
> ranked (always the first of the month) or for just getting all dates
> into a month/year-equivalent format for use in pivot tables.
>
> Enjoy!
>
> _______________________________________________
> Babaseannounce mailing list
> Babaseannounce at www.eco.princeton.edu
> http://www.eco.princeton.edu/mailman/listinfo/babaseannounce
------------------------------------------------------------
Susan Alberts, Dept of Biology, Duke University, Box 90338, Durham NC
27708. Phone 919-660-7272, FAX 919-660-7293
More information about the Babase
mailing list