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

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

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

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 date

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 Software Engineer

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 date

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

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