[plug] MYSQL and the Date

[Kirk Turner]

If you use the type 'timestamp' instead of date it will automatically 
insert the last edited time of the record when an update is done. As far 
as I understand this is the designed purpose of the timestamp type. This 
is a long (same as your system clock) rather than a date so it would be 
a case of using some sort of formatting in php to convert it to a date. 
I would assume there is a function that does that for you, but I know 
very little about PHP so I can help there.

Kirk

Andrew Barbara wrote:

>Hi all,
>Is there a way to get mysql to add the date automatically when it adds an 
>entry?  similar to the auto-increment.
>
>
>Thanks
>Andrew
>
>
>  
>