Wrox Home  
Search P2P Archive for: Go

  Return to Index  

sql_language thread: getting the last change datetime for a table


Message #1 by "bsarna" <sarna24@y...> on Wed, 4 Apr 2001 02:34:24
> Hi there
> Could anybody tell me how to get the last modifying date & time of a 
> table. I would need some function of sql for this.

If you are using SQL Server, define one DateTime field. Use the GetDate() 
function of SQL server to obtain the current date of your system. I don't 
know the case for other DBMS. I hope this helps.

:-)

  Return to Index