Pile of Dross

Beginnings of a query for srm stats:

select to_char(epoch_to_timestamptz(CAST((creationtime/1000) AS integer)),’YYYYIW’),state from getfilerequests where extract(week from epoch_to_timestamptz(CAST((creationtime/1000) AS integer))) <= extract(week from now());

This uses a function epoch_to_timestamptz() which I’ve added to the database taken from PostGreSQL General Bits #40 to basically cast unix epochs into pg’s timestamp type. Now if only the column I actually do the selects on was seconds since epoch, instead of milliseconds since epoch that it actually is.

Had (second-hand) reports of difficulties transferring between CNAF and RAL, and while I could find an incantation of a transfer command that looked it should work but didn’t, however was unable to confirm with user as they’re on holiday.

Also attended Technical Talk by GFT on SATA, SAS and FC

Trackback This Post | Subscribe to the comments through RSS Feed