Datetime Function In Select Statement

[David Altemir]

Why does the DATEIME conversion in the SELECT statement below produce a 210056 SQL syntax error? "act_start_dt" is a DATE type formatted as '2015-01-01' and "act_start_tm" is an integer represented number of seconds since midnight.

The statement works fine without the DATETIME call.

SELECT TOP 100
act_start_dt,
act_start_tm,
DATETIME(act_start_dt, act_start_tm)
FROM
PUB.MyTable;

Continue reading...