[SOLVED] Trouble with Time and Date

[MasterACE14]

Hey,

 

I'm having some trouble with the Time and Date, I'm not sure if I am inserting the right time/date into the database in a Integer column. But I'm also not 100% sure that I am echo'ing the time/date right either.

 

Basically what I do is insert time(); into the database, and then retrieve it and format it with this code:

<?php
// workout Time
		$datetime = $row["time"];
		$year = substr( $datetime, 0, 4 );
		$mon = substr( $datetime, 4, 2 );
		$day = substr( $datetime, 6, 2 );
		$hour = substr( $datetime, 8, 2 );
		$min = substr( $datetime, 10, 2 );
		$sec = substr( $datetime, 12, 2 );
		$orgdate = date("F j, Y",
		mktime( $hour, $min, $sec, $mon, $day, $year ) );

// and I echo this:
echo date("F j, Y", strtotime($datetime));

 

but it keeps echoing

December 31, 1969

 

I'm not sure if I'm inserting the incorrect time/date into the database, or if I'm echoing is incorrect?

 

any help is greatly appreciated. 

 

Regards ACE

[schilly]

Is that PHP time() or SQL time()? Can't remember if they are the same. If it's PHP just do:

 

<?php
// workout Time
		$datetime = $row["time"];
		$orgdate = date("F j, Y", $datetime);

echo $orgdate;

Not sure why you used strtotime when the time column in the db is an int.

[MasterACE14]

Thats worked! thanks heaps 

 

Regards ACE