Converting Openfire IM datetime values in SQL Server to / from VARCHAR(15) and DATETIME data types
- by Brian Biales
A client is using Openfire IM for their users, and would like some custom queries to audit user conversations (which are stored by Openfire in tables in the SQL Server database).
Because Openfire supports multiple database servers and multiple platforms, the designers chose to store all date/time stamps in the database as 15 character…