So sprach chris am Tue, Apr 02, 2002 at 08:26:01PM -0500:
> Is there a way to store the time and date that a record was added within
> MySQL? I want to show the time and date on some of my records and can't seem
> to figure out an easy way to do it. Thanks!
Either use a TIMESTAMP column, which will automatically update everytime you
update/insert a row, or use a DATETIME column which you'll have to set to
the date you want, eg. with 'INSERT INTO Tbl SET DatetimeColumn = NOW();'
Alexander Skwar
--
How to quote: http://learn.to/quote (german) http://quote.6x.to (english)
Homepage: http://www.digitalprojects.com | http://www.iso-top.de
iso-top.de - Die günstige Art an Linux Distributionen zu kommen
Uptime: 6 days 10 hours 29 minutes
---------------------------------------------------------------------
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
