SQL TIMESTAMP from AUDTDATE and AUDTTIME

Question

I have a requirement to create a SQL view with a timestamp field for synching purposes. Converting the AUDTDATE to a date is old hat - creating a combined field was not intuitive (for me). After pecking at it for a few days, I have an approach that works, just wondering if anyone has come up with anything a little more eloquent - Note - the DATEADD is just to bring the final datetime from GMT to ATL time zone:

Django · Answer

I would consider using an optional field vs using the AUDTDATE field just because AUDTDATE is not immutable. And using the optional field gives you full control over the content so you could store the full UTC time. There's also the spectre of daylight savings in case that's important.

kkyle2 · Answer

A different but somewhat similar requirement. On a site that required auditing on specific tables/columns in Sage we created a trigger on the table(s) to store the information in a different DB, "SageAuditing", in the trigger for every Insert, Update or Delete a GetDate is used to capture the Date/time (and other information like the user and host who performed the action and specific Sage table columns that changed). So additional converting of dates wasn't needed, the SQL transaction date is used instead.

Sage 300

SQL TIMESTAMP from AUDTDATE and AUDTTIME

Top Replies

COMMUNITY

COMPANY

PARTNERS

SUPPORT & TRAINING