timestamp substr

NTGre

Hello all
i use this..

$enddate= 20060101000000;

				 $year = substr($enddate, 0, 4);
				 $month = substr($enddate, 4, 2);
				 $day = substr($enddate, 6, 2);
				 $hour = substr($enddate, 8, 2);
				 $minute = substr($enddate, 10, 2);
				 $second = substr($enddate, 12, 2);

to brake a timetamp(14) date stored in my database(20060101000000)

but the result im taking is nor correct.

What i m doing wrong??

rincewind456

You can enclose the number in quotes which will do it, but the best way would be to do it in your database, take a look at DATE_FORMAT .

NTGre

Thnx Friend

i prefer this way cause date_format allways drives me crazy !!!!! :queasy:

Thnx Again !!!!

Weedpacket

And this way doesn't?

What are you getting if it's not correct? And can we see what you're really doing to get $enddate?

NTGre

without the ' ' in the enddate

$enddate=20060101000000; 

$year = substr($enddate, 0, 4);
                     $month = substr($enddate, 4, 2);
                    $day = substr($enddate, 6, 2);
                     $hour = substr($enddate, 8, 2);
                     $minute = substr($enddate, 10, 2);
                     $second = substr($enddate, 12, 2);

echo ("$year/$month/$day/$hour/$minute/$second");

im geting this !!!!!!!!!

2.00/60/10/1E/+1/3

Weedpacket

Oh, I see why we're getting differences. I have floating point precision turned up higher than you.

Try

echo $enddate

, and what do you get with the ' ' in the enddate? And why should that matter if you're getting the value for $enddate out of the database anyway?

http://www.php.net/manual/en/language.types.integer.php

Integer overflow
If you specify a number beyond the bounds of the integer type, it will be interpreted as a float instead. Also, if you perform an operation that results in a number beyond the bounds of the integer type, a float will be returned instead.