Posted by Rob on 05/13/05 10:58

Hello all,

I have a field of type DATE and i like to have a default value for this
field set to the current date. Is this possible to do this in the create
table statement?

ie

CREATE TABLE mytable
(
...
mydate DATE DEFAULT "function to insert current date",
...

)


thanks in advance
Roger

• Next in forum: Username, Passwords and priviliges lost ???
• Prev in forum: Re: Decimal float column definition allowing too many decimalpoints...
• Thread view: Default date

[Reply to this message]