DEFAULT HOUR(NOW()) ? - Ben Lion - com.mysql.lists.win32

4 messages in com.mysql.lists.win32DEFAULT HOUR(NOW()) ?

From	Sent On	Attachments
Ben Lion	09 May 2002 10:08
Joachim Schmidt	09 May 2002 10:10
Joachim Schmidt	09 May 2002 10:16
Paul DuBois	13 May 2002 20:22

Subject:	DEFAULT HOUR(NOW()) ?
From:	Ben Lion (lion...@yahoo.ca)
Date:	05/09/2002 10:08:22 AM
List:	com.mysql.lists.win32

Hi, I am trying to create a table with one column having by default the actual hour of the day. the code looks like create table test (clock TIME, DEFAULT HOUR(NOW())); I get an SQL error. Is there a way to define a default like that in mysql?

I would be grateful if some one can give me a suggestions in this regard

Jochen