Skip to main content
nikos101
nikos101
Inspiring
February 16, 2009
Answered

I'm getting a bunch of Junk for values in a time stamp column: 0x00000000000265FF

  • February 16, 2009
  • 6 replies
  • 873 views
I'm getting a bunch of Junk for values in a time stamp column:

stuff like:

0x00000000000265FF
0x0000000000026601
0x0000000000026602

I was expecting elegible dates.
This topic has been closed for replies.
Correct answer nikos101
after reading this I realise my mistake :)

http://www.sqlteam.com/article/timestamps-vs-datetime-data-types

6 replies

nikos101
nikos101AuthorCorrect answer
Inspiring
February 16, 2009
after reading this I realise my mistake :)

http://www.sqlteam.com/article/timestamps-vs-datetime-data-types
nikos101
nikos101Author
Inspiring
February 16, 2009
the output is found when I do a select stament like

SELECT
dateAdded
FROM deals
nikos101
nikos101Author
Inspiring
February 16, 2009
Basically its an insert statement with the timestamp column omitted:

insert into deals (sellAmount,buyAmount,
buyOrSell,
isUndoable)
D
Dan_Bracuk
Inspiring
February 16, 2009
What code produces that output?
nikos101
nikos101Author
Inspiring
February 16, 2009
My mistake, I'm still getting this problem occuring :(
nikos101
nikos101Author
Inspiring
February 16, 2009
The error seems to have fixed itself, no worries.
Terms & ConditionsAccessibility statement
Using the community Terms of use Privacy Cookie preferences Do not sell or share my personal information ad choicesAdChoices