Predmet:Re: WHEN kako ime na kolona vo tabela
Resenie
Se kreeira view na sledniov nacin:
PreuzmiIzvorni kôd (SQL):CREATE VIEW VIEW01
(
ID,
USERID,
DEVICEID,
DATUM,
INOUT,
VERIFYMODE,
UPDATEUSERID,
UPDATEREMARK,
UPDATEINOUT,
UPDATEWHEN,
UPDATECHANGEWHEN,
WORKCODE
)
AS
SELECT
ID,
USERID,
DEVICEID,
"WHEN",
INOUT,
VERIFYMODE,
UPDATEUSERID,
UPDATEREMARK,
UPDATEINOUT,
UPDATEWHEN,
UPDATECHANGEWHEN,
WORKCODE
FROM ATTENDANT;
i potoa ide SQL :
SELECT * FROM VIEW01 WHERE DATUM = TIMESTAMP '03.06.2015 09:40:52'
ILI MOZE DIREKTNO KAKO
SELECT "WHEN" FROM ATTENDANT
Ovaj post je ureden
1
puta. Posljednja izmjena 16.02.2018 12:55 od strane Gjoreski.