setting datetimestamp default as now() ?

[GeekSupport]

title has a typo: it should read datetime, not datetimestamp. vB won't update the title

is it possible to set datetimestamp default as now() ?

when trying to do

ALTER TABLE `news` CHANGE `date_post` `date_post` DATETIME DEFAULT "NOW()" NOT NULL

then doing

INSERT INTO news SET
rel_uid		= "1",
subject		= "subject here",
message		= "message here",
forum_link	= "link here"

results in

[CRYSTL]

Try NOW() without quotes.

And try setting it to NULL instead of NOT NULL.

[GeekSupport]

dang, other folks are up at this time too

You have an error in your SQL syntax.  Check the manual that corresponds to your 
MySQL server version for the right syntax to use near 'NOW() NULL' at line 1

putting quotes around NOW() fixed the syntax problem, but when performing the same query (above), it still shows all 0's for the date. i changed date_updated to timestamp but date_post (i would think) needs to remain as datetime to keep the original posting date

also, if i set it to null, wouldn't that make 0's default if nothing was entered?