hi.
an alternate solution is to have a table like this:
Create table(
UpdatedDate timestamp(14),
CreationDate timestamp(14),
Info varchar(100)
);
as mysql only automatically updates the _first_ timestamp column in a table.
hth.
-ravi.
-----Original Message-----
From: Sherzod Ruzmetov [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, June 27, 2001 1:40 PM
To: Pete Harlan
Cc: Ravi Raman; Richard Bates; [EMAIL PROTECTED]
Subject: Re: Creating Table with a Default Datetime field
I, c. Then you just have to INSERT INTO it NOW() manually, that works
On Wed, 27 Jun 2001, Pete Harlan wrote:
> TIMESTAMP is not the solution to his problem; he wants the date to
> default to now() when the record is created, not updated.
>
> There's currently no way to do this in MySQL; default values must be
> constants.
>
> --Pete
>
>
>
> > 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
> >
>
>
> ---------------------------------------------------------------------
> 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
