Php Problem to get hour & minutes from smalldatetime types

[shaif]

Hi all, I am working on a module of Php project with SQL server. I design a date filed in the table smalldatetime types. I want to get Hour and minutes. I write the code bellow: Its works for hour but not for minutes. pls give me idea if diff way ...... many thx

$S= gmdate("H", strtotime($row[2])); 
$Sm= gmdate("m", strtotime($row[2]));

[pbmods]

Heya, Shaif.

'm' fetches the day of the month with leading zero. You want 'i' (http://php.net/date).

Also, for performance, consider doing something like this so that you only have to call strtotime() once:

$timeRow = strtotime($row[2]);
$S= gmdate("H", $timeRow);
$Sm= gmdate("m", $timeRow);
 

[shaif]

Heya, Shaif.

'm' fetches the day of the month with leading zero. You want 'i' (http://php.net/date).

Also, for performance, consider doing something like this so that you only have to call strtotime() once:

$timeRow = strtotime($row[2]);
$S= gmdate("H", $timeRow);
$Sm= gmdate("i", $timeRow);
 

Hi Pbmods, Ya its working how ever , its get only rounded minutes such as 30 mins only if have. But if 00.09 , its cant count. Is there any way to get exact minutes pls?

[pbmods]

You want to round to the nearest 30 minutes?

$minutes = ((int) ($minutes / 30 + .5)) * 30;