|
----- Original Message -----
Sent: Friday, February 27, 2004 11:51 AM
Subject: Re: datetime in mysql
sorry , as u said , i did it . it doesn't work for
me .This table i want to view in the Web. So that date and time must fully
automated. Must be keep connect with system date and time.plz help me
...........exactly i need ur help .
thanx
----- Original Message -----
Sent: Friday, February 27, 2004 10:32
AM
Subject: Re: datetime in mysql
At 10:13 PM 2/26/2004, you wrote:
hi ,
i have created datetime field
in the field name "abc".
so i want to get the system date and time
automatically to the abc field for in each records. how can i do that ?can
somebody help me ..................plz
thanx in advance
curlys
Hi Curly,
:)
To save
the current date time into a DateTime column, make sure column is set to Not
Null and just save NULL into that column. Or if you don't want to have to
physically use NULL then you could use a TimeStamp column which will always
update the column whenever the row is changed (for the first TimeStamp column
in the table). TimeStamp is more automatic but may be too automatic if some
times you don't want the timestamp column updated. The choice is
yours.
Mike
|
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
