Subject | Re: How to get the record modifed timestamp |
---|---|
Author | alanpltse |
Post date | 2006-01-23T22:37:25Z |
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:
--- In Firebird-general@yahoogroups.com, "Martijn Tonies"
<m.tonies@u...> wrote:
>MS SQL
> 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 &
> Server
> Upscene Productions
> http://www.upscene.com
> Database development questions? Check the forum!
> http://www.databasedevelopmentforum.com
>