Geeks With Blogs
Brian Biales because blogging is just the easiest way to remember things March 2010 Entries
Converting Openfire IM datetime values in SQL Server to / from VARCHAR(15) or BIGINT and DATETIME data types
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 strings, which get converted to Java Date objects in their code (Openfire is written in Java). EDIT: Turns out these are actually stored as BIGINT, not VARCHAR(15), ......

Posted On Wednesday, March 10, 2010 2:41 PM

Copyright © Brian Biales | Powered by: