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

[nikos101]

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]

The error seems to have fixed itself, no worries.

[nikos101]

My mistake, I'm still getting this problem occuring 😞

[Dan_Bracuk]

What code produces that output?

[nikos101]

Basically its an insert statement with the timestamp column omitted:

insert into deals (sellAmount,buyAmount,
buyOrSell,
isUndoable)

[nikos101]

the output is found when I do a select stament like

SELECT
dateAdded
FROM deals

[nikos101 · Accepted solution]

after reading this I realise my mistake :)

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