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 [email protected] 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.

[email protected] onmouseover=window.status=imagine … a company that supports their product from pride not extortion;return(true)"

David Tod Sigafoos ~ SigSolutions

[email protected] 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...