Format DateTime field from a SOQL query

Question

I am trying to format the datetime field(LastCUUpdateDate) returned from query. I tried the solution given by @Suri in Question#73600 here but it turns out to be GMT always. So, posting the question with the piece of code and what I am trying to achieve.

Page:

<apex:page standardcontroller="account" extensions="conts">
{!account.name}
<apex:pageBlock >
<apex:pageBlockTable value="{!contacts}" var="c">
    <apex:column value="{!c.name}"/>
    <apex:column value="{!c.id}"/>
    <apex:column value="{!c.LastCUUpdateDate }"/>
</apex:pageBlockTable>
</apex:pageBlock>
</apex:page>

extension class:

public class conts {
public conts(ApexPages.StandardController controller) {    }
public string currentRecordId;
public list<contact> getcontacts(){
    currentRecordId  = ApexPages.CurrentPage().getparameters().get('id');
    list<contact> c = [SELECT id, name, LastCUUpdateDate FROM contact WHERE accountId = :currentRecordId];
    return c;
}
}

What I am trying to do ? - return datetime field formatted something like Apr 21' 2015 06:53PM

Answer 1

Instead of using the straight column:

<apex:column value="{!c.LastCUUpdateDate }"/>

Use the format version instead:

<apex:column>
<apex:outputText value="{!c.LastCUUpdateDate}" />
</apex:column>

and modify your controller to do the timezone conversion for you:

public class conts {
public conts(ApexPages.StandardController controller) {    }
public string currentRecordId;
public list<con> getcontacts(){
currentRecordId  = ApexPages.CurrentPage().getparameters().get('id');
list<contact> c = [SELECT id, name, LastCUUpdateDate FROM contact WHERE accountId = :currentRecordId];
list<con> clist = new list<con>();
for(contact x:c){
clist.add(new con(x));
}
return clist;
}

public class con{
  public string name {get; set;}
  public string cd {get; set;}
  public ID id {get; set;}
  public con(Contact c){
    this.name=c.name;
    this.id=c.id;
    this.cd = c.LastCUUpdateDate.format('MMM dd yyyy HH:mm a');
  }
}
}