Hi,
If You take Your really exellent "MySQL Reference Manual", and search for "timestamp"
or look into chapter 6.2, You fill find what You are looking for.
Best regards
Peter
----- Original Message -----
From: CurlyBraces Technologies ( Pvt ) Ltd
To: [EMAIL PROTECTED]
Sent: Friday, February 27, 2004 7:09 AM
Subject: Fw: datetime in mysql
----- Original Message -----
From: CurlyBraces Technologies ( Pvt ) Ltd
To: mos
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 -----
From: mos
To: CurlyBraces Technologies ( Pvt ) Ltd
Cc: [EMAIL PROTECTED]
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]
