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]