Using the reserved word TimeStamp as a field name (Firebird 2.5)

Question

I am expanding the data layer of an existing Firebird 2.5 application in addition to MSSQL and SQLite, but I hit a stumbling block.

I have a field called TimeStamp that stores data / time as a type of TimeStamp. This works fine in MSSQL and SQLite, where the datetime type is, but falls under Firebird. Next SQL:

SELECT SysTrnId,'TimeStamp' from "TRANSACTIONS"

seems to work, but the TimeStamp field is returned as the name of the "CONSTANT" field, and the content is the text "timestamp"

Is it possible to do this in Firebird, or will I have to rename this field and change the code in other data layers.

Answer 1

Firebird - ". , firebird, , , . , TimeStamp, select "TIMESTAMP" ... , .

Answer 2

, , "TimeStamp", .