Sysdate (a synonym of Now()) returns a datetime string. You may want to try
changing dateOf to be datetime. Also, you may want to look at data type
Timestamp: it may do what you want (it does change on both an insert and
update function to current date/time - no default needs to be supplied).
HTH,
- Dave
On 2001.02.16 12:10:06 -0600 Brett Astleford wrote:
> 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
>
> _______________________________________________
> tclug-list mailing list
> tclug-list at mn-linux.org
> https://mailman.mn-linux.org/mailman/listinfo/tclug-list
>
--
Dave Kleist
dkleist at acm.org
"The covers of this book are too far apart."
- Ambrose Bierce