How to get change in CVS after given date

Here's how to get changes in CVS after a given date, in a readable format.

Check out the project, then run the following command.

cvs log -d \>2011-07-28 -N -S | tee changes.text

Or, for only changes in HEAD, do the following.

cvs log -d \>2011-07-28 -N -S -r::HEAD | tee changes.text

Get Xerces and Xalan version in Oracle JDK 1.6

Run this command:

java com.sun.org.apache.xalan.internal.xslt.EnvironmentCheck

For me this outputs:

#---- BEGIN writeEnvironmentReport($Revision: 1.8 $): Useful stuff found: ----
version.DOM.draftlevel=2.0fd
java.class.path=.;C:\Program Files\Java\jre6\lib\ext\QTJava.zip
version.JAXP=1.1 or higher
java.ext.dirs=C:\Program Files\Java\jre6\lib\ext;C:\Windows\Sun\Java\lib\ext
version.xerces2=Xerces-J 2.6.2
version.xerces1=not-present
version.xalan2_2=Xalan Java 2.6.0
version.xalan1=not-present
version.ant=not-present
java.version=1.6.0_21
version.DOM=2.0
version.crimson=not-present
sun.boot.class.path=C:\Program Files\Java\jre6\lib\resources.jar;C:\Program Files\Java\jre6\lib\rt.jar;C:\Program Files\Java\jre6\lib\sunrsasign.jar;C:\Program Files\Java\jre6\lib\jsse.jar;C:\Program Files\Java\jre6\lib\jce.jar;C:\Program Files\Java\jre6\lib\charsets.jar;C:\Program Files\Java\jre6\classes
version.SAX=2.0
version.xalan2x=not-present
#----- END writeEnvironmentReport: Useful properties found: -----
# YAHOO! Your environment seems to be OK.

XML Indenter to use with MarkLogic jEdit plugin

The XML Indenter module is officially obsolete, but still works and is required by MLJeditXQuery-0.7.1.

You can find it here.

Convert a Orace timestamp to a datetime you can use in an hsqldb

Here's how you can convert a timestamp column in an ORACLE DB into a string you can use as a datetime in an INSERT statement in HSQLDB.

select to_char(current_timestamp, 'yyyy-mm-dd hh24:mi:ss.ff9') from dual;

Convert a mysql date or time to a datetime you can use in an hsqldb

Here is how to convert a mysql date or time to a datetime you can use in an hsqldb INSERT statement.

select date_format(name_of_date_column, '%Y-%m-%d %H:%i:%s') from table_containing_date_column

Using date format from Toad for MySQL

By default in my locale (UK) Toad for MySQL displays this date format for 9:30ish on July 10.

'10/07/2009 09:30:48'

However, if I try to use that format in a SQL command in the editor, for example

SELECT * FROM foo WHERE changed = '10/07/2009 09:30:48'

I get this error

Commands out of sync; You can't run this command now

The default date format is 'YYYY-MM-DD HH:MM:SS' so I could do

SELECT * FROM foo WHERE changed = '2009/07/10 09:30:48'

or use STR_TO_DATE and do

SELECT * FROM foo WHERE changed = STR_TO_DATE('10/07/2009 09:30:48','%d/%m/%Y %H:%i:%s');

Getting a change log from cvs

Thank you cvs2cl!

It creates a nice delta of the comments in changes between tagged releases. For example, to get the changes from tag R8 to tag R9 for the module called jam:

cvs2cl.pl --delta R8:R9 jam

Though the help says this:

--delta FROM_TAG:TO_TAG
 Attempt a delta between two tags (since FROM_TAG up to and including
 TO_TAG). The algorithm is a simple date-based one (this is a hard
 problem) so results are imperfect.