Hi,

What's the SQL equivalent for
 X := EncodeDate(Year, Month, Day) + EncodeTime(Hour, Minute,  Second, MSec);

TIA,
Lucian

Lucian,


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)

--
Fernando Dias
[Team Elevate]


Em 21-01-2012 17:46, Lucian escreveu:
> Hi,
>
> What's the SQL equivalent for
>    X := EncodeDate(Year, Month, Day) + EncodeTime(Hour, Minute,  Second, MSec);
>
> TIA,
> Lucian
>

Thanks a lot
Lucian

Lucian,

in addition to Fernando's post: you can easily create your own function.
If you want to use integers e.g.:

CREATE FUNCTION "EncodeDate" (IN "FYear" INTEGER, IN "FMonth" INTEGER,
IN "FDay" INTEGER)
RETURNS DATE
BEGIN
  RETURN CAST(
    CAST(FYear as VARCHAR) + '-' + CAST(FMonth as VARCHAR) + '-' +
CAST (FDay as VARCHAR)
  AS DATE);
END

Regards Uli