Re: [sqlite] Re: timestamp to date in a trigger

1970). > You probably want > > strftime('%d-%m-%Y', new.tstp, 'unixepoch') It's exactly what I need. Charly CAULET - To unsubscribe, send email to [EMAIL PROTECTED] -

[sqlite] timestamp to date in a trigger

't seem to work : >INSERT INTO contrat(tstp) VALUES("1184834152"); >SELECT * FROM contrat; 1|1184834152|16-08-3239253 ----- Thank you, Charly CAULET -

Re: [sqlite] Re: Re: trigger and new.*

ing" while 10 sec, and after an core dump happends... -- Charly CAULET membre de www.208assistance.org ID jabber : [EMAIL PROTECTED] clé gpg : 0x7DE10F3C (pgp.mit.edu) signature.asc Description: Ceci est une partie de message numériquement signée

Re: [sqlite] Re: trigger and new.*

n "INSERT" that executes an update, and I had some triggers on "UPDATE" that executes any other updates... So it was an infernal loop. Thank you for helping, Igor. Charly CAULET - To unsubscribe, send email to [EMAIL PROTECTED] -

[sqlite] trigger and new.*

them in a "BEFORE" trigger, because if I do it in an "AFTER" trigger, I would have to use an UPDATE query and it would lead to a deadlock (I also have some triggers on the UPDATE statement...). Thank you for helping Have a nice day Charly CAULET - To unsubscribe, send email to [EMAIL PROTECTED] -