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.
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”
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.
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