Subject Re: How to get the record modifed timestamp
Author alanpltse
So is there a way to know when did the record be last modified/inserted ?


--- In Firebird-general@yahoogroups.com, "Martijn Tonies"
<m.tonies@u...> wrote:
>
> Hi,
>
>
> Support questions should go to firebird-support@yahoogroups.com
>
> Nevertheless ...
>
> > Is there a function in the SELECT statement I can find out the
> > record's last insert/last modified timestamp ?
>
> No, because such a timestamp does not exist.
>
> > eg.
> > SELCT "timestamp", EMP_ID, EMP_NAME
> > FROM EMPLOYEE
> > WHERE EMP_ID = 100
>
> Martijn Tonies
> Database Workbench - tool for InterBase, Firebird, MySQL, Oracle &
MS SQL
> Server
> Upscene Productions
> http://www.upscene.com
> Database development questions? Check the forum!
> http://www.databasedevelopmentforum.com
>