Need an Idea for create Trigger

I have one Field Modified On with datetime datatype in sql Table.And the Field is not null.

I need to create trigger for update the Modified on Field while the record will created.

How can I do this??