CODEWITHSUNDEEP
c#sqldb2
Cannon
Cannon

Reputation: 2783

DB2 Timestamp Query shows differetn value in excel

I am using c#, with DB2, a query 

SELECT current timestamp FROM sysibm.sysdummy1

shows correct value in Toad, but throgh code, gets value formatted in DD/MM/YY HH:MM format when I show it in excel.

Upvotes: 0

Views: 746

Answers (1)

Ian Bjorhovde
Ian Bjorhovde

Reputation: 11042

The timestamp value is the same*, it's just how it's being displayed in Excel. You can change the formatting in Excel to display the value as it shows in DB2 if you'd like.

Note: A DB2 timestamp is accurate to microseconds, but Excel only supports milliseconds. So you will lose a little precision.

Upvotes: 1

Related Questions