Re: Creating Table with a Default Datetime field

2001-06-28 Thread Paul DuBois
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 TIMEST

Re: Creating Table with a Default Datetime field

2001-06-28 Thread Gerald Clark
No. Since the string "now()" is not a valid date it is equivalent to 0, so MySQL inserts the current date and time. 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

Re: Creating Table with a Default Datetime field

2001-06-28 Thread Kaneda K
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 YY

Re: Creating Table with a Default Datetime field

2001-06-27 Thread Rich Duzenbury
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 >

RE: Creating Table with a Default Datetime field

2001-06-27 Thread Sherzod Ruzmetov
ilto:[EMAIL PROTECTED]] > Sent: 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: > > > &g

RE: Creating Table with a Default Datetime field

2001-06-27 Thread Ravi Raman
erzod Ruzmetov [mailto:[EMAIL PROTECTED]] Sent: 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 th

RE: Creating Table with a Default Datetime field

2001-06-27 Thread Sherzod Ruzmetov
: 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: > >

RE: Creating Table with a Default Datetime field

2001-06-27 Thread Ravi Raman
- 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

Re: Creating Table with a Default Datetime field

2001-06-27 Thread Gerald Clark
gt;> 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, J

Re: Creating Table with a Default Datetime field

2001-06-27 Thread Sherzod Ruzmetov
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 Tab

Re: Creating Table with a Default Datetime field

2001-06-27 Thread Hannes Niedner
ck 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- >> F

Re: Creating Table with a Default Datetime field

2001-06-27 Thread Pete Harlan
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(), > Infovarc

RE: Creating Table with a Default Datetime field

2001-06-26 Thread Ravi Raman
: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

Creating Table with a Default Datetime field

2001-06-26 Thread Richard Bates
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( Creat