[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