Re: [PHP-DB] MySQL timestamp field update problem

2002-09-11 Thread bbonkosk
>From the MySQL Manual: The TIMESTAMP column type provides a type that you can use to automatically mark INSERT or UPDATE operations with the current date and time. If you have multiple TIMESTAMP columns, only the first one is updated automatically. If YOU want control over this, us the DATETI

Re: [PHP-DB] MySQL timestamp field update problem

2002-09-11 Thread Paul DuBois
At 11:59 -0500 9/11/02, Rob Day wrote: >Hi all, >I have a table in MySQL with the following field: > 'time_date' timestamp(14) NOT NULL >When a record is inserted into the table, NULL is inserted into the >time_date field giving me a normal timestamp with the time of the INSERT. >That much i

[PHP-DB] MySQL timestamp field update problem

2002-09-11 Thread Rob Day
Hi all, I have a table in MySQL with the following field: 'time_date' timestamp(14) NOT NULL When a record is inserted into the table, NULL is inserted into the time_date field giving me a normal timestamp with the time of the INSERT. That much is fine. However, it is necessary for me to u

RE: [PHP-DB] MySQL timestamp field in different time zone

2002-06-13 Thread Ryan Jameson (USA)
o the calculation either on the sql or upon displaying but it has to happen on the client. <>< Ryan -Original Message- From: bill [mailto:[EMAIL PROTECTED]] Sent: Thursday, June 13, 2002 2:03 PM To: [EMAIL PROTECTED] Subject: Re: [PHP-DB] MySQL timestamp field in different time zone No,

Re: [PHP-DB] MySQL timestamp field in different time zone

2002-06-13 Thread bill
you saying that you plan to move the MySQL server around to different >time zones? Why would you do that? > > -Original Message- > From: Ryan Jameson (USA) > Sent: Thursday, June 13, 2002 9:44 AM > To: [EMAIL PROTECTED] > Subject: RE: [PHP-DB] MySQL timestamp field in d

RE: [PHP-DB] MySQL timestamp field in different time zone

2002-06-13 Thread Ryan Jameson (USA)
BTW... are you saying that you plan to move the MySQL server around to different time zones? Why would you do that? -Original Message- From: Ryan Jameson (USA) Sent: Thursday, June 13, 2002 9:44 AM To: [EMAIL PROTECTED] Subject: RE: [PHP-DB] MySQL timestamp field in different time zone

RE: [PHP-DB] MySQL timestamp field in different time zone

2002-06-13 Thread Ryan Jameson (USA)
ld be nice if the browser sent timezone information in the header, but as far as I know it does not. <>< Ryan -Original Message- From: bill [mailto:[EMAIL PROTECTED]] Sent: Thursday, June 13, 2002 8:55 AM To: [EMAIL PROTECTED] Subject: [PHP-DB] MySQL timestamp field in different t

[PHP-DB] MySQL timestamp field in different time zone

2002-06-13 Thread bill
How do I get a MySQL timestamp field to update itself when the server is in a different time zone, i.e., I want it to have the date for my time zone. The field updates itself automatically, of course, without being referenced in the SQL query. I'd like to avoid having to change every query to in

RE: [PHP-DB] MySQL Timestamp

2001-07-18 Thread Jeff Oien
Thanks. I was using MySQL by DuBois book as a reference. Jeff > According to the manual, 12 is YYMMDDHHMMSS and 14 is MMDDHHMMSS. > > http://www.mysql.com/documentation/mysql/bychapter/manual_Reference.html#DATETIME > > > "Jeff Oien" <[EMAIL PROTECTED]> wrote: > I have a field that's time

[PHP-DB] MySQL Timestamp

2001-07-18 Thread Jeff Oien
I have a field that's timestamp(12) which should be MMDDhhmm but what I'm getting is 010718125000 what I was expecting was 200107181250 How can I get what I was expecting? Thanks. Jeff Oien -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For add