[RESOLVED] Insert Datetime into query

[tazdog]

1st for testing and understanding I'm trying to get the date and time inserted into the record when someone enters data. I have tried a few things that I have found browsing around the internet, but everything I try it acts as null and enters in all zero's..

So where can I find some good information on how to get this to work in the sql query on phpmyadmin before I attempt to add this to my php code..

thanks
Scott

[Roger_Ramjet]

You need to set the column to Timestamp data type

Now pay attention to the manual because the timestamp behaviour is version specific.

Also read the user notes at the bottom of the pages for some very usefull tips.

[tazdog]

This is what I'm trying to do in my query

insert into test
values ('null', 'name', 'field2', 'field3', 'datetime here')

I have tried a few different things but it always enters all zero's into the
field...

Just not sure of the proper syntax to use

thanks

[Roger_Ramjet]

You do not supply a value or a place-holder for a timestamp column - it is automatically filled by the db engine.

A timestamp column will always begin with the insert date and time. It can be updated by subsequent updates to the record - when and how is version specific and you should read the manual. You can configure 2 timestamp columns on a table - 1 for insert and 1 for last update. Again refer to the manual.