[RESOLVED] Timestamp insert issue: Windows / Linux

[reeksy]

Hi.

Using PHP 4 / MySQL.

Bit of a tricky one here!

I have a field within a table which has the type 'timestamp(14)' assigned to it. I use the timestamp to see when the row was last inserted/updated. This procedure works fine however I’ve come across a bit of a problem. I’ve developed the system on a Windows system; however the application is being hosted on a Linux box. Now whenever the date is pulled out it displays the wrong information.

I can see where the problem is occurring. It's occurring when the date is inserted/updated in the database. An example of a timestamped field (in the database) on the Windows build looks like this: 20060721110113 however on the Linux box the data looks like this: 2006-07-21 11:01:13

The formatting is clearly different however the insert queries are exactly the same.

Does anyone know why the timestamp would be inserted differently on different operating systems?

Thanks, Jon.

[tsinka]

Hi,

please check if MySQL >= 4.1 is installed on the Linux system. As of MySQL 4.1 timestamp fields are just like datetime fields.

I think the problem is not the different OS but the different MySQL version.

Thomas

[reeksy]

That would be it then!

So do newer versions of MySQL (MySQL >= 4.1) use the following timestamp format: YYY-MM-DD HH:MM:SS ?

[tsinka]

The manual contains a section about the differences.

Also read the chapter about date and time functions.

Thomas

[reeksy]

Thanks. Resolved