MySQL timestamp field will change format - consequences for SMF

[Harald]

Hello all,

My ISP will update the MySQL and as a first step will convert the format of the content of all fields of type "timestamp".

AFAICS the only data field of that type is the field "logTime" in the table "log_online". Correct?

Format now: "20041117111014"
Format to come: "2004-11-17 11:10:14"

I'm a newbie as far as MySQL and PHP are concerned, so my questions are:

• Is the field "logTime" in the table "log_online" really the only one of type "timestamp" in the db?
• Does the format change in the db affect SMF in any way?
• Will I have to change anything in the scripts?
• If so: in which script and where and what/how?

Thanks for any help.
Harald

[[Unknown]]

1. Yes.
2. No.
3. No.
4. N/A.

No worries ...

-[Unknown]

[Harald]

Thank you [Unknown],
Big relief 

Harald