Grab just time and AM or PM from timestamp

[run_GMoney]

I guess the subject pretty much says it all. I want to get the time in the format HH:MM AM/PM from a 14 numbered timestamp (20030524080000). I tried to use the mktime and date functions but just got myself all twisted up. I know the format I want is h:i A. Any ideas?

[nnichols]

It would be easier to format it when you select the data from the db in the first place -

SELECT DATE_FORMAT(field_name, '%r')
outputs - "hh:mm:ss AM/PM"

or

SELECT DATE_FORMAT(field_name, '%h:%i %p')
outputs - "hh:mm AM/PM"

Hope this helps 😉

[run_GMoney]

I'm not sure I follow what you mean. Could you clarify it a bit for me?

[nnichols]

I am assuming that this data is coming from a database.

Instead of doing

SELECT timestamp_field FROM table

use

SELECT DATE_FORMAT(timestamp_field, '%h:%i %p') FROM table

Hope this makes sense to you

[ahundiak]

Formatting during the query will work but it's not always the ideal solution. This function does not give you the exact format you want but get it working and then it should be easy to tweak.

function format_date($date)
{    

  $timestamp = mktime(0,0,0,
    substr($date,4,2),substr($date,6,2),substr($date,0,4));

  $date_str = date('D M d',$timestamp);
  return format_noblanks($date_str);
}

Ooops. I posted the date routine instead of the time routine.

function format_time($time)
{
  $timestamp = mktime(substr($time,0,2),substr($time,2,2),0,1,1,2001);

  $time_str = date('h:i a',$timestamp);
  return format_noblanks($time_str);
}