devxlogo

June 29, 2000

Changing Database Names

Question: How do I change the name of a database? Answer: From another database, maybe sysmaster, type: RENAME DATABASE oldname TO newname.

Conversion of Unix Epoch Time in SQL

Question: How do I convert the Unix epoch time into a readable date/time format? Answer: Informix doesn’t have a built-in function that I know of for this. However, a function