Date convert from SQL

[mssakib]

Hi

 

In sql we have dates like this 134238

 

In php it shows -  19:10:11  . we can make it by using date('d.m.y', $date); where $date=134238 ;

 

my question is how can we turn 19:10:11 in to 134238 using PHP

 

 

[Pikachu2000]

None of that makes any sense. How about posting actual code and real values instead of expecting people to guess what you're doing.

[xyph]

is 19:10:11 dd:mm:yy or hh:mm:ss ?

 

If it's DD:MM:YY you'd use

<?php 

$date = '19:10:11';
list( $day,$month,$year ) = explode( ':', $date, 3 );
$stamp = mktime(0,0,0,$month,$day,$year);
echo $stamp;

?>

[dougjohnson]

Human readable to UTC example:

1316549989 = mktime(15,19,49,09,20,2011)

$utctime = mktime($hour,$minutes,$seconds,$month,$day,$year);

-------------------------------

UTC to Human readable example:

2011-09-20 15:19:49 = date('Y-m-d G:i:s',1316549989)

$humanreadabletime = date('Y-m-d G:i:s',$actual_utc_time);

[mssakib]

But i want to do reverse... how to do that

[mssakib]

SOLVED ... thx to xyph

[dougjohnson]

19:10:11

$date_entered = "19:10:11";
$dateexplode = explode(':',$date_entered);
$year = $dateexplode[2];
//$year = 11
$month = $dateexplode[1];
//$month = 10
$day = $dateexplode[0];
//$day = 19
$convert = mktime(0,0,0,$month,$day,$year);

[mssakib]

SOLVED though thx bro .....