Date's, ODBC, STrange Format

Tracer

I am using ODBC to retrive from a c-tree db. The dates have been stored as YYYYzzz (January 1, 1975 would be 1975001 and december 31, 1975 would be 1975365). I need to display my query results to the screen in human format: mm/dd/YYYY.

I have tried the following

function rx30_to_unix($rxdate)
{
$utime = strtotime($rxdate, Yz);
$result = date("MY FORMAT);
return $result;
}

however the strtotme function keeps failing and returning a -1

any ideas?

TTT

www.php.net/date

Tracer

Yes, but that doesn't seem to be working...

and PHP stores day of year (z) from 0 to 364....My imported data is 001 to 365 (Which I can probably overcome by nesting IF statements to pad the 0's)

But I have to get the date($, Yz) to work correctly first and it is returning very strange values

Weedpacket

Use substr() (or sscanf(), if you like) to get the $year and $day parts of the ODBC date out.
$timestamp=mktime(0,0,0,1,$day,$year);
date('YOUR FORMAT',$timestamp);

Tracer

My Balding Hero!

Here si the complete fxn if anyone else needs it

function rx30_to_human($rxdate)
{
$year = substr($rxdate, 0, 4);
$day = substr($rxdate, -3);

$timestamp=mktime(0,0,0,1,$day,$year);
$result =date('m/d/Y',$timestamp);
return $result;
}

Thank You!
😃