Subject Re: [Firebird-general] How to get the record modifed timestamp
Author Martijn Tonies
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