CREATE FUNCTION "EncodeTimeStamp" (
IN "Year" INTEGER,
IN "Month" INTEGER,
IN "Day" INTEGER,
IN "Hour" INTEGER,
IN "Minute" INTEGER,
IN "Second" INTEGER,
IN "MSecond" INTEGER)
RETURNS TIMESTAMP
BEGIN
DECLARE Result TIMESTAMP;
SET Result=
CAST(
CAST(Year AS VARCHAR) + '-' +
CAST(Month AS VARCHAR) + '-' +
CAST(Day AS VARCHAR) + ' ' +
CAST(Hour AS VARCHAR) + ':' +
CAST(Minute AS VARCHAR) + ':' +
CAST(Second AS VARCHAR) + '.' +
CAST(MSec AS VARCHAR)
AS TIMESTAMP);
RETURN Result;
END