Icon View Thread

The following is the text of the current message along with any replies.
Messages 1 to 1 of 1 total
Thread LIB - func - EncodeTimeStamp.sql
Mon, Feb 6 2012 8:57 AMPermanent Link

Lucian

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
Image