Re: Hello! Date question....

2002-02-12 Thread Paul DuBois
At 18:49 +0100 2/8/02, Jim Hatridge wrote: >Hi all... > >This is my first post to the list. I've been working on MySQL now for about a >week and really like it. I have a question that I can't find in any of the >books or how-tos. > >When I add a line to my customer's table I need it to put today's

RE: Hello! Date question....

2002-02-12 Thread John Lodge
See the manual reference to the 'timestamp' type. -Original Message- From: Jim Hatridge [mailto:[EMAIL PROTECTED]] Sent: Friday, February 08, 2002 5:50 PM To: [EMAIL PROTECTED] Subject: Hello! Date question Hi all... This is my first post to the list. I've been w

Re: Hello! Date question....

2002-02-12 Thread DL Neil
Hi Jim, Welcome to our relatively?relationally happy band. > This is my first post to the list. I've been working on MySQL now for about a > week and really like it. I have a question that I can't find in any of the > books or how-tos. A whole week and no post... > When I add a line to my custo

RE: Hello! Date question....

2002-02-12 Thread Eric Mayers
inal Message- > From: Jim Hatridge [mailto:[EMAIL PROTECTED]] > Sent: Friday, February 08, 2002 9:50 AM > To: [EMAIL PROTECTED] > Subject: Hello! Date question >=20 > Hi all... >=20 > This is my first post to the list. I've been working on MySQL=20 > now for abo

Hello! Date question....

2002-02-12 Thread Jim Hatridge
Hi all... This is my first post to the list. I've been working on MySQL now for about a week and really like it. I have a question that I can't find in any of the books or how-tos. When I add a line to my customer's table I need it to put today's date in the "indate" column. Is there anyway

Re: Hello! Date question....

2002-02-09 Thread Jim Hatridge
On Friday 08 February 2002 19:28, Eric Mayers wrote: > Jim, > > What you're asking about is the "timestamp" data type. > > Look at : http://www.mysql.com/doc/D/A/DATETIME.html > > In a nutshell, if you assign 'null' to a timestamp column it will put in > value of 'NOW()'. > > Eric Mayers > Softwar

Re: Hello! Date question....

2002-02-08 Thread DL Neil
Hi Jim, Welcome to our relatively?relationally happy band. > This is my first post to the list. I've been working on MySQL now for about a > week and really like it. I have a question that I can't find in any of the > books or how-tos. A whole week and no post... > When I add a line to my custo

RE: Hello! Date question....

2002-02-08 Thread Eric Mayers
inal Message- > From: Jim Hatridge [mailto:[EMAIL PROTECTED]] > Sent: Friday, February 08, 2002 9:50 AM > To: [EMAIL PROTECTED] > Subject: Hello! Date question > > Hi all... > > This is my first post to the list. I've been working on MySQL > now for about a &g

Re: Hello! Date question....

2002-02-08 Thread Paul DuBois
At 18:49 +0100 2/8/02, Jim Hatridge wrote: >Hi all... > >This is my first post to the list. I've been working on MySQL now for about a >week and really like it. I have a question that I can't find in any of the >books or how-tos. > >When I add a line to my customer's table I need it to put today's

Hello! Date question....

2002-02-08 Thread Jim Hatridge
Hi all... This is my first post to the list. I've been working on MySQL now for about a week and really like it. I have a question that I can't find in any of the books or how-tos. When I add a line to my customer's table I need it to put today's date in the "indate" column. Is there anyway