[TCLUG] sql

[Brett Astleford]

I know this really isn't a admin thing, but I need help with a sql
statement.

<server info>
        Mandrake 7.0
        MySQL 3.23
</server info>

CREATE TABLE tblBlah (
        blahId integer NOT NULL PRIMARY KEY AUTO_INCREMENT,
        dateOf date Default sysdate()

);

I basically want mysql to input the current date when I enter table data...
I can't get sysdate to output the current date,  i've changed the the data
type, i've used curdate() and other mysql date functions...any ideas?

Brett Astleford
Platinum Design Group