[eluser]John_Betong[/eluser]
[quote author="lszanto" date="1245491503"]I have looked around and it doesn't seem to be possible but in active record I use the insert() function to insert my data. For a date field in MySQL I need to use the NOW() function built into MySQL. Is there any way to do this while still in Active Record?
Thanks in advance, Luke[/quote]
Hi lszanto,
Initially I found Php and MySql handling of dates is overwhelming. I tried numerous ways to store NOW() and eventually left it up to MySql to do it all for me.
[code]
Check out:
1. field type: TIMESTAMP
2. field default: CURRENT_TIMESTAMP
3. field attributes: on update CURRENT_TIMESTAMP
[code]