At 10:38 27/06/2001 -0700, you wrote:
Sorry, for quoting the manual but this might be just another example where
it could have the answer right away:
Hannes
http://www.mysql.com/doc/D/A/DATETIME.html
On my own mysql version :
Date TIMESTAMP default now(),
Works correctly, the date is
At 11:57 AM +0200 6/28/01, Kaneda K wrote:
At 10:38 27/06/2001 -0700, you wrote:
Sorry, for quoting the manual but this might be just another example where
it could have the answer right away:
Hannes
http://www.mysql.com/doc/D/A/DATETIME.html
On my own mysql version :
Date TIMESTAMP default
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
-
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(
CreationDateDATETIME
: 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(
CreationDateDATETIME
() 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
-
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
]
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
: Wednesday, June 27, 2001 2:10 PM
To: Ravi Raman
Cc: Pete Harlan; Richard Bates; [EMAIL PROTECTED]
Subject: RE: Creating Table with a Default Datetime field
Wait, I didn't get the following:
an alternate solution is to have a table like this:
Create table(
UpdatedDatetimestamp(14
]
Subject: RE: Creating Table with a Default Datetime field
Wait, I didn't get the following:
an alternate solution is to have a table like this:
Create table(
UpdatedDatetimestamp(14),
CreationDatetimestamp(14),
Infovarchar(100
Only the first timestamp is updated by MYSQL. Create two timestamp
fields. MySQL will maintain the first one. Set timestamp2 to null when
the record is created.
Regards,
Rich
At 10:54 AM 6/27/01 -0500, Pete Harlan wrote:
TIMESTAMP is not the solution to his problem; he wants the date to
How do I get a default date time in the create table clause...
I have tried
Create table(
CreationDateDATETIMEDEFAULT NOW(),
Infovarchar(100)
);
Create table(
CreationDateDATETIMEDEFAULT NOW(),
Infovarchar(100)
);
Create table(
: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(
CreationDateDATETIMEDEFAULT NOW(),
Infovarchar(100)
);
Create table(
CreationDate
13 matches
Mail list logo