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
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.