Ed Lentz
|
Posted: 11/09/2003, 8:22 AM |
|
Hi
I have a MySql DB, using PHP, and CCS2. How could I enter a date in a field in my MySql table when I update a record? Is there a FAQ or Tutorial?
Thanks
Ed
|
|
|
ryan
|
Posted: 11/19/2003, 3:54 AM |
|
There is a timestamp data type in MySQL right? Can you try that please set a database field to a timestamp :)
|
|
|
StephenK
|
Posted: 11/19/2003, 6:00 AM |
|
Select your record
On your data tab select custom update type > table
Click on custom update
Hit the + next to parameters
-field is Date or DateTime field in Table; type > text
-parameter source is type > code expression; name > 'now()'
|
|
|
bb
|
Posted: 11/19/2003, 11:23 PM |
|
Assuming that you want to default a date to 12/31/2037 - do this
set the default value to: mktime(0,0,0,12,31,2037)
|
|
|
|