What syntax should I use to store attribute like
* birthDate
* anniversary
* foundationDate
* establishmentDate
* registrationDate
These information are dates, not time. I am not sure if I should use
Generalised Time for them. They share these characteristics:
1) time is not important (as well as timezone offset); Date is the only
information these attribute holds;
2) date may not be complete, e.g.
I. The company is founded on 2000, but we don't know on what month
and day.
II. the girl was born on July, 20th, but she wouldn't let you know
the year of her birth;
The possibility of holding unknown part of date is important because we
cannot always collect Month and Day the companies in our database
established, but only the year, but company establishment date is
important data to our database and should be kept as much as possible.
Evolution (Novell's product) keep this data as Directory String in this
format:
%Y-%m-%d
Evolution's method not be the best because
I. it is Directory String, LDAP web client application I am
designing may not know how to tell the difference between a
Directory String (should render a input box) or a date.
II. our web LDAP client is designed to handle multiple language
versions of the same data. According to related RFC all
Directory String are multi-lingual, thus our application provide
3 language version of BirthDate, which looks ridiculous on the
webpage.
III. I am not sure if dates are kept in this way can we search e.g.
companies established in recent 5 years, through a LDAP filter
Evolution's method is good because:
I. This is compatible with Evolution. Yes we do use Evolution in
our company;
II. It's possible to hold unknown part of date, though Evolution may
cannot read such data: "2006-??-??".
What would you do for keeping such data?
--
锐业软服(国内业务) http://www.realss.cn
Real SoftService http://www.realss.com
销售咨询(Sales Department): 0086 592 20 99987 (Chinese, German,
English)
国际业务(International Sales): 0086 10 8460 6011 (German and English)
联系:厦门大学科技园,嘉庚二号楼6楼
邮政:厦门大学2312号信箱(邮编361005)
signature.asc
Description: 这是信件的数 字签名部分
--- You are currently subscribed to [email protected] as: [EMAIL PROTECTED] To unsubscribe send email to [EMAIL PROTECTED] with the word UNSUBSCRIBE as the SUBJECT of the message.
