Order Time AUDTTIME?

[Blinz]

Goal- Create report, using sql query, to show time of order placement.

I'm delving through the accpac tables, the only constant identifier I can find for determining order TIME, is OEORDHO.AUDTTIME. The oeordho.audttime seems to be the only time field that does not change through the process.

Question, is there a more static time field, and how would you convert this time field to EST using a SQL query.

Already tried converting milliseconds, and deducting GMT time
ROUND(OEORDHO.AUDTTIME / 10000 - 500, 0). Yields negative results......

 

[ettienne]

AUDTTIME is the UTC (or GMT) time the record was last updated, not the time the record was added. Adjust the time for your time zone, so for EST deduct 5 (6 for day light savings) hours. The format is HHMMSSSS, so 14290230 will translate to 2:29 pm UTC.
There is no other field for recording time.

 

[Rajender123]

How to understand the AUDTTIME in the Accpac

 

[ettienne]

Is that a question or did you just not complete your sentence?