Dauditnew Timestamp

Lansford Spears

Is there a way to retrive the timestamp from the dauditnew table? Currently i am only able to see the date.

Find more posts tagged with

Comments

Nizar Ghazal

Hi Lansford,

How are you retrieving this field?

The AuditDate column should include the full timestamp, as well, beyond just the date.

Thanks,

Nizar

Colin_Schmidt

You have to format it in a LR. Oracle will show the DATE, but the time is there: TO_CHAR(auditdate, ‘yyyy/mm/dd HH24:mi:ss’). For SQL Server, you may have to do nothing in an LR, but look it up in a SQL Server book or on-line.

Colin J

From: eLink Entry: Content Server LiveReports Forum <livereportsdiscussion@elinkkc.opentext.com>
Sent: Friday, August 17, 2018 10:46 AM
To: eLink Recipient <devnull@elinkkc.opentext.com>
Subject: Dauditnew Timestamp

Dauditnew Timestamp

Posted bynghazal@opentext.com (Ghazal, Nizar) On 08/17/2018 11:40 AM

Hi Lansford,

How are you retrieving this field?

The AuditDate column should include the full timestamp, as well, beyond just the date.

Thanks,

Nizar

[To post a comment, use the normal reply function]
Topic:	Dauditnew Timestamp
Forum:	Content Server LiveReports Forum
Content Server:	My Support