how to find last updated date [message #606007] |
Fri, 17 January 2014 06:18 |
|
preethia
Messages: 8 Registered: January 2014 Location: chennai
|
Junior Member |
|
|
Hi,
I want to find last modified date and time in a table.
If i'm changing description for a particular id then it will update the date and time change in last updated column. I want to list the columns which has been modified last using oracle sql.
Please help me.
|
|
|
|
|
Re: how to find last updated date [message #606014 is a reply to message #606013] |
Fri, 17 January 2014 07:14 |
pablolee
Messages: 2882 Registered: May 2007 Location: Scotland
|
Senior Member |
|
|
preethia wrote on Fri, 17 January 2014 13:12pablolee --Max function is listing all the date. no it's not. Your query might be listing all the dates, that just means that you've written the wrong query.
Quote:it is not working properly. it absolutely IS working properly, the error is yours. Now what that error is is impossible to tell as you have posted no code.
|
|
|
|
Re: how to find last updated date [message #606019 is a reply to message #606017] |
Fri, 17 January 2014 07:43 |
pablolee
Messages: 2882 Registered: May 2007 Location: Scotland
|
Senior Member |
|
|
preethia wrote on Fri, 17 January 2014 13:36pablolee -can you please give me a sample query
A sample query of what? I have no idea what columns you have? You do. You said that you ran a query and got all dates back, post that query.
|
|
|
Re: how to find last updated date [message #606027 is a reply to message #606017] |
Fri, 17 January 2014 11:28 |
|
preethia
Messages: 8 Registered: January 2014 Location: chennai
|
Junior Member |
|
|
I have two tables-- table name= main_table( this is main table)
columns= id,number, desc,createdby,created date, last updated by,last updated date and etc.
table name=history_table( in this table I pick up the last updated date values and storing it in seperate table)
columns= id(foreign key of main_table), desc,lastupdated date
in this, the last updated date is not displaying in history table.
In history table as well as main table, i created lastupdateddate column as sysdate.
I updated description by using id (primary key).
|
|
|
|
|
|