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-12 Thread Eric Mayers
[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 about a=20 week and really like it. I have a question that I can't find=20 in any

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

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

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
:[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 week and really like it. I have a question that I can't find in any of the books

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