| Subject | Date and time in Stored Proc | 
|---|---|
| Author | Niall Scott | 
| Post date | 2003-03-26T08:21:20Z | 
Hi
 
I would like to have a table holding a list of tables and the date/time
they were last changed. This would be updated by a Stored Procedure
which is fired by the After Post of each table.
Is there anyway I can get the current date/time from inside Firebird 1.0
or will I have to create a UDF.
 
Thanks
 
Niall R Scott
IS Support
Cameron Controls
Aberdeen
scottn@...
 
 
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
This e-mail is confidential, may contain proprietary information
of the Cooper Cameron Corporation and its operating Divisions
and may be confidential or privileged.
This e-mail should be read, copied, disseminated and/or used only
by the addressee. If you have received this message in error please
delete it, together with any attachments, from your system.
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
[Non-text portions of this message have been removed]
            I would like to have a table holding a list of tables and the date/time
they were last changed. This would be updated by a Stored Procedure
which is fired by the After Post of each table.
Is there anyway I can get the current date/time from inside Firebird 1.0
or will I have to create a UDF.
Thanks
Niall R Scott
IS Support
Cameron Controls
Aberdeen
scottn@...
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
This e-mail is confidential, may contain proprietary information
of the Cooper Cameron Corporation and its operating Divisions
and may be confidential or privileged.
This e-mail should be read, copied, disseminated and/or used only
by the addressee. If you have received this message in error please
delete it, together with any attachments, from your system.
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
[Non-text portions of this message have been removed]