Posted by Simon on 03/01/06 21:29

insert into table mytable(creationdate Date) (sysdate())
"Tony Peardon" <rWorldDesigns@yahoo.ca> wrote in message
news:xGLMf.7129$M52.1209@edtnps89...
> Hi all,
>
> How do I timestamp a table? I have a table that contains references to the
> files of a website. I want to track when the file is created, modified,
and
> published, and I also want to track if and when the file should be
> refreshed, and so, I need to know how to make a timestamp.
>
> create table files
> (
> ---- cut
> created date default ??thedate??, -- how do I timestamp?
> modified date default ??thedate?? on update ??thedate??, --can I reset
> the modified date automatically?
> interval date default ??10 days??, -- can I do this? how?
> refresh date default ??thedate+interval?? --can I add two dates??
> published date on update ??resetrefresh?? -- can the refresh date be
> reset automatically when the file is published?
> );
>
> Am I even barking up the right tree, or is this sort of stuff better
handled
> with php?
>
> Please help.
>
> Thanks.
>
>

[Back to original message]