I didn't understood modifiers utility, reading this page
(http://www.sqlite.org/cvstrac/wiki?p=DateAndTimeFunctions). Thank you
Igor and Richard for explainations and help.
> I'm not sure what 1184834152 is supposed to represent,
It is an UNIX timestamp (number of seconds since 1970).
> You prob
Charly Caulet <[EMAIL PROTECTED]>
wrote:
CREATE TRIGGER tstpTOdate1 AFTER INSERT ON contrat
BEGIN
UPDATE contrat SET date1=strftime("%d-%m-%Y", new.tstp) WHERE
UniqueID=new.UniqueID;
END;
But when strftime doesn't seem to work :
INSERT INTO contrat(tstp) VALUES("1184834152");
SELECT * FROM co
2 matches
Mail list logo
