[RESOLVED] Problems with date and mktime()

[ale1981]

Hi,

I am having a prob inserting a timestamp into database.
My form passes a manually entered date in this format dd-mm-yy (eg 01-02-06).
I then use this code to seperate the date, month and year;

	$date = explode("-", $date);
	$date = mktime(0,0,0,$date[1],$date[0],$date[2]);

Problem is that the timestamp doesnt seem to change, no matter what date i input, it stores in the database as 8388607

Thanks in advance.

[Plasma]

Why would it be 14 numbers?

It would be 10 if its a date < 2036

[devinemke]

ale1981 wrote:

Problem is that the timestamp doesnt seem to be 14 numbers when I insert it into the database.

why are you expecting a 14 digit integer? the unix timestamp for today (2006-02-09) is 1139461200 which has 10 digits.

[ale1981]

My error, the date field in the db was only allowing for 7 digits, therefore the proper timestamp wasnt being entered, sorry, been a long day!