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 working on MySQL no

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
Jim,=20 What you're asking about is the "timestamp" data type. =20 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 Software Engineer > -Original Message- > From: Jim Hatridge [m

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
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 Software Engineer > -Original Message- > From: Jim Hatridge [mailt

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