Skip to main content
nikos101
nikos101
Inspiring
February 16, 2009
解決済み

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

  • February 16, 2009
  • 返信数 6.
  • 881 ビュー
I'm getting a bunch of Junk for values in a time stamp column:

stuff like:

0x00000000000265FF
0x0000000000026601
0x0000000000026602

I was expecting elegible dates.
このトピックへの返信は締め切られました。
解決に役立った回答 nikos101
after reading this I realise my mistake :)

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

返信数 6

nikos101
nikos101作成者解決！
Inspiring
February 16, 2009
after reading this I realise my mistake :)

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

SELECT
dateAdded
FROM deals
nikos101
nikos101作成者
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
nikos101作成者
Inspiring
February 16, 2009
My mistake, I'm still getting this problem occuring :(
nikos101
nikos101作成者
Inspiring
February 16, 2009
The error seems to have fixed itself, no worries.
契約条件Accessibility statement
Using the community Terms of use Privacy Cookie preferences Do not sell or share my personal information ad choicesAdChoices