Hints & Tricks

Latest revision as of 02:44, 3 May 2011

@@ Line 1: / Line 1: @@
+#Redirect [[Tips]]
-'''Deleting a few recently created prims'''
-Occaisionally, one ends up with one or more prims that one would like to delete on a region but doesnt know where they are. Here is one possible solution to that problem.
-Given the site, http://epochconverter.com, one can enter a human date and get a binary such as an epoch. For instance, 4/21/2008 19:00:34GMT is "1208797234"
-Then, from a sqlite3 prompt or a mysql prompt, one can do:
- select CreationDate from prims where CreationDate>"1208797234";
- delete from prims where CreationDate>"1208797234";