OpenSimulator · EN

Practical tools for OpenSimulator

Free web tools for generating UUIDs and converting dates used in OpenSimulator databases.

UUID generator

Generate UUID identifiers when an OpenSimulator application or development task needs a unique identifier. Before inserting a UUID into a database, verify schema constraints and relationships between tables.

Open UUID generator

https://bloodmoonpack.com/uuid/

Timestamp converter

Convert timestamp values to readable dates and back. This can help inspect or prepare date values in OpenSimulator databases, including fields used for avatar account creation dates, depending on the database schema in use.

Open timestamp converter

https://bloodmoonpack.com/timestamp/

Precautions before making SQL changes

Unix timestamps are generally expressed as seconds since 1970-01-01 00:00 UTC; some applications use milliseconds. Verify the column type and meaning before modifying any value. Never change a production account creation date without a backup, identifying the exact table and column, and reviewing service impact.

A viewer field described as an avatar’s “birthday” does not necessarily represent a person’s real birth date: in OpenSimulator it may refer to account creation. Use the value and time zone expected by your installation.

Related guides

MySQL and MariaDB administration · LSL and OSSL reference