Some trans has no timestamp

[oushu1zhangxiangxuan1]

1. What did you do?

Parsing trans data from block leveldb of fullnode snapshot 20210425

2. What did you expect to see?

Get trans timestamp

3. What did you see instead?

Some trans has no timestamp in raw data.
For example

trans_hash	block_num
e778d0a204d72dc2b3507c17823f797dc5d35fdf34ac1e17280421f2c7c36063	28466248
783b564cedaf323c8dc955cd2c4a9cb00e14a1dc5df784ceacc2c1e1e96f2576	28519316
2c171162d498bab62adcb8826155bef171d56eaf63086448316ba72e975733a9	28519302

[oushu1zhangxiangxuan1]

Another problem

There is always a disparity in seconds between my parsed result and tronscan.org
For example:
trans_hash f2281a79ab38039aa375ec308d30e1824ec5805f26b6a444dfded4cf02aaa829 in block 26937276

I got timestamp: 1611191710144 and transformed it to datetime with postgresql(without timezone) and python:

without time zone: 2021-1-21 01:15:10
with time zone: 2021-1-21 09:15:10

But in transcan.org, the time is

AND
https://tronscan.org/#/transaction/f2281a79ab38039aa375ec308d30e1824ec5805f26b6a444dfded4cf02aaa829

[Benson0224]

Hi,
The time displayed on Tronscan is the block timestamp. not transaction timestamp.
The timestamp of the block you mentioned above is 1611191724000, after transferred it is the same with tronscan.

You can get the block timestamp from this this API:
https://api.trongrid.io/wallet/gettransactioninfobyid?value=f2281a79ab38039aa375ec308d30e1824ec5805f26b6a444dfded4cf02aaa829

[oushu1zhangxiangxuan1]

Hi,
The time displayed on Tronscan is the block timestamp. not transaction timestamp.
The timestamp of the block you mentioned above is 1611191724000, after transferred it is the same with tronscan.

You can get the block timestamp from this this API:
https://api.trongrid.io/wallet/gettransactioninfobyid?value=f2281a79ab38039aa375ec308d30e1824ec5805f26b6a444dfded4cf02aaa829

Thanks! And the time in transaction detail page on Tronscan is block time too?

[Benson0224]

Hi,
The time displayed on Tronscan is the block timestamp. not transaction timestamp.
The timestamp of the block you mentioned above is 1611191724000, after transferred it is the same with tronscan.

You can get the block timestamp from this this API:
https://api.trongrid.io/wallet/gettransactioninfobyid?value=f2281a79ab38039aa375ec308d30e1824ec5805f26b6a444dfded4cf02aaa829

Thanks! And the time in transaction detail page on Tronscan is block time too?

Yes.

[oushu1zhangxiangxuan1]

这种交易一般是自己写代码创建的， 没有指定时间戳， 交易中的时间戳被没有被用到， 所以指不指定都没啥影响"

[oushu1zhangxiangxuan1]

1. What did you do?

Parsing trans data from block leveldb of fullnode snapshot 20210425

2. What did you expect to see?

Get trans timestamp

3. What did you see instead?

Some trans has no timestamp in raw data.
For example

trans_hash block_num
e778d0a204d72dc2b3507c17823f797dc5d35fdf34ac1e17280421f2c7c36063 28466248
783b564cedaf323c8dc955cd2c4a9cb00e14a1dc5df784ceacc2c1e1e96f2576 28519316
2c171162d498bab62adcb8826155bef171d56eaf63086448316ba72e975733a9 28519302

这种交易一般是自己写代码创建的， 没有指定时间戳， 交易中的时间戳被没有被用到， 所以指不指定都没啥影响"

[Benson0224]

Thanks for your contribution to java-tron.
This issue will be closed as the answer is already clear now.
Please feel free to re-open this issue if you still see it, thanks.