So sprach chris am Tue, Apr 02, 2002 at 08:26:01PM -0500:
^
You're quite ahead of me, timewise *G*
> 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
Add a D
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 wi
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 add a timestamp column to your t
Add a date/time column and dump the current time into it when you do an
insert
jason
- Original Message -
From: "chris" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Wednesday, April 03, 2002 11:26 AM
Subject: time and date
> Is there a way to store the time and date that a record
Check the manual for the TIMESTAMP datatype. Will hold the last update time per record
abd therefore the insert time that you want.
regards,
thalis
--
No excellent soul is exempt from a mixture of madness.
-- Aristotle
On Tu
It's in the manual. Check the datatypes section, and the now() mysql
function.
On 4/2/02 6:26 PM, "chris" <[EMAIL PROTECTED]> wrote:
> 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 figu
