Date and Time strings to timestamp

dcjones

Hi all,

I am working on a script which gets it's data from a CSV file. The CSV file contains lines of data.

example data: 01091009401010DATA

Embedded in the data row is a date and time in the format of "0109100940" day 01, month 09, year 10, hours 09, and mins 40. I have created an array to split the date portion into six elements and the time portion into 4 elements.

I now need to merge $Date and $Time into one variable, $EstDateTime, then convert the result into a timestamp.

$data = str_split($record["FIELD1"]);

$DateR = $data[10]."".$data[11]."-".$data[12]."".$data[13]."-".$data[14]."".$data[15];

$TimeR = $data[20]."".$data[21]."".$data[22]."".$data[23];

$EstTime = str_split($TimeR);

$EstDateTime = $Date." ".$EstTime[0]."".$EstTime[1].":".$EstTime[2]."".$EstTime[3];

Can this be done and if so can anyone point me in the right direction.

NogDog

If you have all the date/time parts, you can simply use them as parameters to [man]mktime/man to get a UNIX timestamp integer as the result, if that's what you're looking for.

dcjones

Hi NogDog,

Many thanks for your reply.

It's a nightmare trying to format this.

For testing this is what I have:

$data = str_split("030910");
$time = str_split("1815");

$Date =  date("Y-m-d", mktime("$time[0] $time[1]","$time[2] $time[3]","0",("$data[2] $data3]","$data[0] $data[1]","$data[4] $data[5]");

But this I know is wrong because it throws errors.

I've tried a few compinations of formatting the code but they fail.

Could you give me an idea as to how the format should be.

Again, many thanks in advance.

dcjones

Hi NogDog,

Cancel that request for more help. I think I have it solved.

$data = str_split("030910");
$time = str_split("1815");

$DateR = $data[0]."".$data[1]."-".$data[2]."".$data[3]."-".$data[4]."".$data[5];
$Month = $data[2]."".$data[3];
$Day   = $data[0]."".$data[1];
$Year  = $data[4]."".$data[5];

$TimeR = $time[0]."".$time[1].":".$time[2]."".$time[3];
$Hours = $time[0]."".$time[1];
$Mins  = $time[2]."".$time[3];



$Date =   mktime($Hours, $Mins , 0, $Month, $Day, $Year);

print $Date;

NogDog

This might be a little cleaner:

$data = "030910";
$time = "1815";

list($day, $mon, $yr, $hr, $min) = str_split($data . $time, 2);
$timestamp = mktime($hr, $min, 0, $mon, $day, 2000 + $yr);
// test:
echo date("d/m/Y H:i", $timestamp);

🙂

johanafm

Take care to ensure that times are always zero-leftpadded. Else a time between midnight and noon, like 915 would give you hour: 91, minute: 5.