create automatic datetime when update the data in postgresql(phppgadmin)

Question

create automatic datetime(date with timestamp) when update the data in postgresql(phppgadmin) on database table

Plese advise me thanks

http://www.postgresql.org/docs/current/static/plpgsql-trigger.html#PLPGSQL-TRIGGER-EXAMPLE — , Feb 25 '15 at 07:45
Create a trigger (and of course the trigger function) like a_horse_with_no_name already mentioned. — Frank Heikens, Feb 25 '15 at 09:50

score 0 · Answer 1 · answered Feb 25 '15 at 07:35

0

1.if you use timestamp type in the column when you update the record then date time also updated 2.if you use varchar type in the column when you fire a query

demo

$sql = "update table_name set field_name=now() where your condition";

answered Feb 25 '15 at 07:35

suresh kumawat

1

i am asking database update the field not a parameter – Sniper Feb 25 '15 at 07:52

create automatic datetime when update the data in postgresql(phppgadmin)

1 Answers1