I setup a table in the database like so:
C_REG_USERS underneath I have several fields one which is for datetime. The user fills the registration form out and it dumps the info into the database. I have the datatime field setup like this.

Field Name reg_time
Field Type DATETIME
Length/Set
Attributes
Null NOT NULL
Default 0000:00:00 00:00:00
Extra

It works but when someone does registered in this field it shows something like this
2000-09-
89
93:91:63

Could someone tell me what I am doing wrong?

Joey

:confused:

It would help if you would post the sql statement that you are using to insert that data.

webhost, your post doesn't make any sense. Log into mysql, select your database and type:describe table; (where table is the table name you're trying to insert this information) and paste the result in here. Also give us your SQL line(s) from your PHP script.

I found the problem to be in the php script, vendor stated to look into messages.php3 I did couldn't find area. Once I find the script I will paste in here,

Thanks for the interest.

Joey