40
dear friends,
I need your support.
I'm extracting data from NAV tables with timestamp without problems.
I simply convert the timestamp to bigint and apply the required where conditions.
The question is: How can i know the NAV timestamp for a specific date? I need this timefield to execute the first extract.
regards,
PM
*This post is locked for comments
Hi
The field TIMESTAMP is not a date or time stamp. Its a binary used to keep track of record vesions of the same record. I guess you extract directly from SQL ?
Use "Entry No." for transaction tables.
From technet:
timestamp is a data type that exposes automatically generated binary numbers, which are guaranteed to be unique within a database. timestamp is used typically as a mechanism for version-stamping table rows. The storage size is 8 bytes.
BR Per
Share
Report
All responses (
Answers (
