[BioSQL-l] dates and terms

[mark.schreiber at novartis.com]

Hello -

Many records that might be stored in BioSQL have associated date fields. 
Biojava stores these as value in bioentry_qualifier_value with the term_id 
pointing to the Term for date.

This seems to place a serious limitation on searching by date. I would 
like to be able to search for sequences entered between X and Y or before 
X etc. Has anyone come up with a workaround for date operations on 
VarChar2 or Strings?

Thanks

Mark Schreiber
Principal Scientist (Bioinformatics)

Novartis Institute for Tropical Diseases (NITD)
10 Biopolis Road
#05-01 Chromos
Singapore 138670
www.nitd.novartis.com

phone +65 6722 2973
fax  +65 6722 2910


______________________________________________________________________
The Novartis email address format has changed to 
firstname.lastname at novartis.com.  Please update your address book 
accordingly.
______________________________________________________________________