Dear All,

I have one collection with more than 300 items where erroneously user has 
submitted items giving them correct day, month but incorrect year under 
published date, by rectifying the error I would like to know if there is SQL 
statement that I could use to modify the entire items so they can use similar 
year on date but keep different day and month, the itema reflect 2010 as year 
published instead of 1987.
If there is any additional info to clarify any of the above details I would be 
glad to give it to you.


Regards,
Lewatle

<html><p><font face = "verdana" size = "0.8" color = "navy">This communication 
is intended for the addressee only. It is confidential. If you have received 
this communication in error, please notify us immediately and destroy the 
original message. You may not copy or disseminate this communication without 
the permission of the University. Only authorized signatories are competent to 
enter into agreements on behalf of the University and recipients are thus 
advised that the content of this message may not be legally binding on the 
University and may contain the personal views and opinions of the author, which 
are not necessarily the views and opinions of The University of the 
Witwatersrand, Johannesburg. All agreements between the University and 
outsiders are subject to South African Law unless the University agrees in 
writing to the contrary.</font></p></html>
------------------------------------------------------------------------------
Free Next-Gen Firewall Hardware Offer
Buy your Sophos next-gen firewall before the end March 2013 
and get the hardware for free! Learn more.
http://p.sf.net/sfu/sophos-d2d-feb
_______________________________________________
DSpace-tech mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/dspace-tech
List Etiquette: https://wiki.duraspace.org/display/DSPACE/Mailing+List+Etiquette

Reply via email to