When doing some unrelated investigation of groups, we found that the DB field CREATEDON seems to be set wrong.

This is best illustrated with the following query:

SELECT
COUNT(1),
CREATEDON
FROM
SAKAI.SAKAI_REALM GROUP BY CREATEDON

On our DB, we see:

COUNT(1) CREATEDON
----------- ----------------------
3964 1/12/2006 4:10:59 PM
1622 1/12/2006 4:10:58 PM
4 6/27/2006 6:17:33 PM
3 1/12/2006 4:10:57 PM
3 6/27/2006 6:17:34 PM

There are dates other than this of course. However, one of the 3964 is a group that was created today(not Jan 12, 2006)

I'm at a loss to explain the variance, ie why some realms seem to have a good CREATEDON, but others do not) but the real problem I see is why the createdon date is inherited from a previously created realm(or why its anything other than the DB current date function really.) This makes it very difficult to tell when a realm was created.