hi.
check out the TIMESTAMP column type...maybe TIMESTAMP(14) as the column
type?
you can then format the date accordingly with...uh...DATE_FORMAT() in your
select statements...
hth.
-ravi
-----Original Message-----
From: Richard Bates [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, June 26, 2001 3:00 PM
To: [EMAIL PROTECTED]
Subject: Creating Table with a Default Datetime field
How do I get a default date time in the create table clause...
I have tried
Create table(
CreationDate DATETIME DEFAULT NOW(),
Info varchar(100)
);
Create table(
CreationDate DATETIME DEFAULT "NOW()",
Info varchar(100)
);
Create table(
CreationDate DATETIME DEFAULT SYSDATE(),
Info varchar(100)
);
Create table(
CreationDate DATETIME DEFAULT "SYSDATE()",
Info varchar(100)
);
Create table(
CreationDate DATETIME DEFAULT CURRENT_DATE(),
Info varchar(100)
);
Create table(
CreationDate DATETIME DEFAULT "CURRENT_DATE()",
Info varchar(100)
);
All without the quote return with invalid syntax.
With the quote inserts "000-00-00 00:00:00" meaining invalid date.
==================================
=== Richard Bates
=== TELEHOUSE America
==================================
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php