right Etienne
Jose Gerardo Amaya Giron wrote: > > Thanks I now understand the difference. I can use a timestamp If I used a > database to log access for example I only make an insert to > the other fields and the timestamp insert the current time and date right? > > Gerardo Amaya > > "Alok K. Dhir" wrote: > > > You probably want to start with datetime rather than timestamp, as > > timestamp comes with some additional magic to auto-set it for you and > > you may not want this. A good source for this type of information is, > > incidentally, the MySQL reference, at www.mysql.com. > > > > > -----Original Message----- > > > From: [EMAIL PROTECTED] > > > [mailto:[EMAIL PROTECTED] > > > m] On Behalf Of Fabio Roger > > > Sent: Wednesday, November 28, 2001 12:35 PM > > > To: Jose Gerardo Amaya Giron; [EMAIL PROTECTED] > > > Subject: Re: date type > > > > > > > > > timestamp is a good start > > > > > > ----- Original Message ----- > > > From: "Jose Gerardo Amaya Giron" <[EMAIL PROTECTED]> > > > To: <[EMAIL PROTECTED]> > > > Sent: Wednesday, November 28, 2001 2:42 PM > > > Subject: date type > > > > > > > > > > Hello all I got a a simple question, I changing from access > > > to MySQL. > > > > I have in access some fields that have date and time. What type of > > > > field in MySQL can handle this. > > > > > > > > thanks > > > > > > > > Gerardo Amaya > > > > > > > > > > > > > > > --------------------------------------------------------------------- > > > > Before posting, please check: > > > > http://www.mysql.com/manual.php (the manual) > > > > http://lists.mysql.com/ (the list archive) > > > > > > > > To request this thread, e-mail <[EMAIL PROTECTED]> > > > > To unsubscribe, e-mail > > > <[EMAIL PROTECTED]> > > > > Trouble unsubscribing? Try: > > > http://lists.mysql.com/php/unsubscribe.php > > > > > > > > > > > > > > > > --------------------------------------------------------------------- > > > Before posting, please check: > > > http://www.mysql.com/manual.php (the manual) > > > http://lists.mysql.com/ (the list archive) > > > > > > To request this thread, e-mail <[EMAIL PROTECTED]> > > > To unsubscribe, e-mail > > > <[EMAIL PROTECTED]> > > > Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php > > > > > > > > --------------------------------------------------------------------- > Before posting, please check: > http://www.mysql.com/manual.php (the manual) > http://lists.mysql.com/ (the list archive) > > To request this thread, e-mail <[EMAIL PROTECTED]> > To unsubscribe, e-mail <[EMAIL PROTECTED]> > Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php -- Etienne Marcotte Specifications Management - Quality Control Imperial Tobacco Ltd. - Montreal (Qc) Canada 514.932.6161 x.4001 --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
