Post reply

SQL SERVER 2000 EQUIVALENT OF SQL SERVER 2008 TIME DATATYPE

  • October 15, 2009 at 11:41 am

    #74105

    I need to define a columnin a SQL Server 2000 table which will accept data from a SQL Server 2008 table and column datatype TIME. Any suggestions?

  • October 15, 2009 at 12:35 pm

    #1066440

    There is no direct equivalent. Which way you should go is determined by what you need to do with it. Pass the date along with it from 2008 and store the whole thing as a datetime in my opinion. You can use computed columns to simulate the separate date and time portions.

    Seth Phelabaum

    Consistency is only a virtue if you're not a screwup. 😉

    Links: How to Post Sample Data[/url] :: Running Totals[/url] :: Tally Table[/url] :: Cross Tabs/Pivots[/url] :: String Concatenation[/url]

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply