Home

How to get time stamp from agile plm database

Hi All,

I am selecting Rev Incorp Date,Effectivity Date,upd_date from database.
But here i am not able to find timestamp.

How can i get time stamp from database.

Thanks & regards,
Dinesh.

Agile User Asked on February 9, 2016 in No Category.
Add Comment
Cancel
3 Answer(s)

Hi Dinesh,

what do you mean for Timestamp?
Is it about the date when the item has been released for that version? In that case you have to select the “Rev Release Date”

Cancel
Agile Angel Answered on February 9, 2016.
Add Comment
Cancel

Hi Antonio,

I am able to find date but i need a particular time .

For example:
If the change made at same day couple of times.In this we need to find latest change.
How we can able to find that latest change by using latest updated time..

In this case i need a particular time to get latest change.

NOTE: In UI it is giving with time stamp along with date,but in database its stored only date is stored.

Regards,
Dinesh.

Cancel
Agile User Answered on February 17, 2016.
Add Comment
Cancel

Hi Dinesh,

in the REV table, you can find the association between Item, Change and version. Here there is the column EFFECTIVE_DATE which contains (at least in agile 9.3.2) the full date time (Field is of type DATE).
As Date field, you can use standard oracle comparator to extract this information

I hope that it can be helpful

Cancel
Agile Angel Answered on February 17, 2016.
Add Comment
Cancel

Your Answer

By posting your answer, you agree to the privacy policy and terms of service.