Templeate column lable Date Format

[Rahul]

I want to set date format to template column same like below

2/28/2014 11:54:42.832921 AM


Please help me how to set date format like this.

Thanks in davance

[Rahul]

It's bound column sorry how to set date form for bound column

[Princy]

Hi Rahul,

Please try the following code snippet to set the date for a BoundColumn.

ASPX:

<telerik:GridBoundColumn DataField="OrderDate" HeaderText="OrderDate" UniqueName="OrderDate"
 DataType="System.DateTime" DataFormatString="{0:G}" />

Thanks,
Princy

[Rahul]

No still not working still it giving same. Not able to display form like this  2/28/2014 11:54:42.832921 AM

[Rahul]

Please note : My date column data type is timestamp in database not datetime.

[Princy]

Hi Rahul,

As per my knowledge this is not possible to achieve since the SQL timestamp is not actually a datetime data type. TimeStamp is a binary sequence. There is no correlation to a DateTime.

Thanks,
Princy