Post reply

Timestamp Showing As

  • January 25, 2006 at 7:11 am

    #89247

    I created a SQL Server 2000 database with a timestamp column (datatype is Timestamp).  Whenever I do an insert, I do not see a unique binary number in the timestamp column.  I see "<Binary>".  I don't understand why a binary number is not being generated.

    Does anyone know why this is happening?

    Thank You,

    Dawn

  • January 25, 2006 at 11:43 am

    #617000

    With which tool you see <binary> (EM?)

    I see the different values with query analyzer.

     

  • January 26, 2006 at 11:14 am

    #617267

    I can't thank you enough!!  I just ran a query using Query Analyzer rather than looking directly at the results in the database through Enterprise Manager.  Now I see the binary number.

    I am new to databases, SQL And Enterprise Manager, so I didn't even have enough sense to run a query using Analyzer.

    Thanks Again!!!

    Dawn

  • January 26, 2006 at 12:26 pm

    #617295

    You're welcome

Viewing 4 posts - 1 through 3 (of 3 total)

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