TIMESTAMP Issue

[Haraldo]

I have read up a bit on this. However i am having a few issues.

I am running a testing server using iis 5 with a MySQL database.

The timestamp stored in my server for example looks something like:

15/03/2004 13:00:00

15032004130000 (this is the way the timestamp is stored in the GUI i am using)

I have chosen TIMESTAMP(14) because i need the hours minutes and seconds.

When i use the

date("d m Y" strtotime($timestamp)) with TIMESTAMP(8)

it works i get the right date etc but i need the hours etc. Any other TIMESTAMP apart from TIMESTAMP(14) in the database doesn't work it reverts all timestamps to:

02/12/0001

I can't change it cause either it reverts back automatically or it gives me an error.

So when i try an use TIMESTAMP(14) in the same context i get the following output:

Warning: date(): Windows does not support dates prior to midnight (00:00:00), January 1, 1970 in c:\inetpub\

http://wwwroot\websites\swiftforum\messages.php

on line 103

I have changed nothing but the TIMESTAMP from 8 to 14.

Im so mixed up now cause i've been working on it for a while. If anyone can help it would be great...

 

[Haraldo]

I solved my problem...

If this was relevant to anyone else visit this url it solve it for me. I ended up not even using and date function etc

http://www.weberdev.com/get_example.php3/1427

Blue Skys!