Results 1 to 3 of 3

Thread: timestamp

  1. #1
    Join Date
    Sep 2006

    Unanswered: timestamp

    hello I put a time stamp in one of my column and it says binary data in the field. How do i make that binary data turn into a real date and time. If this is possible how do I separate the date from the time in the results or would I have to do this myself. Also, I need to sort the results by date can this be done?

    Sorry for the stupid questions my sql book (sql demystified) does not elaborate. Thanks

  2. #2
    Join Date
    Feb 2004
    In front of the computer
    Provided Answers: 54
    A SQL Server timestamp column has nothing to do with date and time like it does in other products (notably DB2). In SQL Server, a timestamp is basically a counter for the number of changes (INSERT/UPDATE/DELETE operations) that have taken place in a given database.

    You almost certainly want to use a DATETIME column.


  3. #3
    Join Date
    Nov 2005
    San Francisco, CA
    See this
    Success is the ability to go from one failure to another with no loss of enthusiasm.
    - Sir Winston Churchill

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts