This is irritating me.. it seems like it should work but isnt.
I have a query.. the base query
SELECT TO_CHAR(t.startdate,'hh24:mi:ss') AS starttime,
TO_CHAR(t.finishdate,'hh24:mi:ss') AS finishtime, taskid,
startdate, finishdate
FROM TASK t
returns
STARTTIME FINISHTIME LPAD(TASKID,5)
Anyone have any idea how to go about doing this?
This is irritating me.. it seems like it should work but isnt.
I have a query.. the base query
SELECT TO_CHAR(t.startdate,'hh24:mi:ss') AS starttime,
TO_CHAR(t.finishdate,'hh24:mi:ss') AS finishtime, taskid,
startdate, finishdate
FROM TASK t
SELECT TO_CHAR(t.startdate,'hh24:mi:ss') AS starttime,
TO_CHAR(t.finishdate,'hh24:mi:ss') AS finishtime, LPAD(taskid,5),
startdate, finishdate
FROM TASK t
WHERE
TO_DATE('08/21/2004','mm/dd/') = TRUNC(t.startdate)
AND TO_DATE('08/21/2004','mm/dd/') = TRUNC(t.finishdate)
AND
3 matches
Mail list logo