Timestamp Question.

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.

Re: Timestamp Question.

insert into table mytable(creationdate Date) (sysdate())
"Tony Peardon" 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.
>
>