|
|||||||||
|
|||||||||
| |||||||||
|
|||||||||
|
|||||||||
| |||||||||
|
|
|
| |||||||||
 |
|
|
«
Previous Thread
|
Next Thread
»
|
Thread Tools | Search this Thread | Rate Thread | Display Modes |
Codewalkers Forums Sponsor:
|
|
|
|
#1
March 13th, 2004, 06:09 PM
|
|||
|
|||
|
inserting date into date field
i have DATE field in my MySQL database. that field is responsible for storing the date when someone registered as a user on my site. in my INSERT statement i used NOW() for the value for the field and it doesn't work. How do i insert the current date into that field?
|
|
#2
March 13th, 2004, 06:23 PM
|
|||
|
|||
|
RE: inserting date into date field
try using curdate() instead of now()...now() returns the date AND time, curdate just returns the date.
|
|
#4
March 13th, 2004, 08:59 PM
|
|||
|
|||
|
RE: inserting date into date field
Yes.
|
|
#5
March 14th, 2004, 04:58 PM
|
|||
|
|||
|
RE: inserting date into date field
You could set the MySql Field type to timestamp(8)
That would give you the date the record was created. Just a thought. Have a great day -Jim
|
|
| Viewing: Codewalkers Forums > Other Technologies > Database Help > inserting date into date field |
| Thread Tools | Search this Thread |
| Display Modes | Rate This Thread |
|
|
 |
|
|
|
|
|
Del.icio.us
Digg
Google
Spurl
Blink
Furl
Simpy
Y! MyWeb
Linear Mode
