Re: [Tavi-devel] function html_timestamp in tavi 0.26

[Even H. <eve...@pv...>]

On Wed, May 04, 2005 at 01:41:52PM +0200, Fredrik Jonsson wrote:
> My provider runs SuSE Linux with MySQL 4.0.18 and this code makes 
> dates show up something like "4: 2005051200", not so nice.
[...]
>  // This need more tuning according to sql_mode: MAXDB-setting,  
>  // DATETIME vs TIMESTAMP

On the web site someone stated that MySql 4.x gave some difficulties
regarding the date format. I tested it briefly on my setup, and it gave 
the same response as before. 

But I read the manuals and found that this could be changed if one
changed some options within MySql-configuration. In a temporary solution
I decided, to use the old syntax for 3.x version (which I knew worked),
and made a temporary solution to 4.x. 

And here's my point that in order to eliminate this bug I need to get
myself a test setup using MySql 4.x and that I haven't been able to do
yet. When this is up I will test out which parameters makes the
different dates appear, and then try to work around it. I believe this
issue also affects the input of dates, but I haven't been able to test
this properly yet. 

So if someone can shed the light onto the subject of when the 4.x version
returns the old date format, and when its using the new date format,
please do!  And in addition, if someone also know how this affect
inputting dates (in accordance with time zones), please inform me!

Regards,
Even Holen
-- 
<e><  Even Holen, eve...@pv..., http://www.pvv.ntnu.no/~evenh/   :-)
      developer of WikkiTikkiTavi, see http://tavi.sourceforge.net/