OI Time -] MS SQL 7.0 DateTime (OpenInsight Specific) [Revelation On-Line Wiki]

Sign up on the Revelation Software website to have access to the most current content, and to be able to ask questions and get answers from the Revelation community

At 06 APR 2000 11:03:17AM Russell Stokley wrote:

OpenInsight Specific

I'm sure I can create a dictionary symbolic to get around this problem, but surely someone has figured this out by now. How do setup a conversion of a time field in OI to come out as a datetime field in MS SQL Server 7.0. Mine all look like dates.

Thanks

At 06 APR 2000 11:37AM dsig@teleport.com wrote:

Russell,

This is a 'guess' but you probably have to pass date and time or passed data (time) will look to sqlserver as date. I do believe the sqlserver does store datetime together.

dsig@teleport.com onmouseover=window.status=imagine … a company that supports their product from pride not extortion;return(true)"

David Tod Sigafoos ~ SigSolutions

dsig@teleport.com Cell:503-341-2983

At 06 APR 2000 11:46AM Stephen S. Revelation wrote:

Russell,

Just in case you might have missed it, this KB Article contains OpenInsight datawarehousing SQL Server specifics.

-Stephen

View this thread on the forum...