asked on

DateTime format problem

Hi
Can anyone help with this datetime problem.
In my BLL i have: this.travelNewsDateInserted = Convert.ToDateTime(travelNewsDateInserted.ToString("ddd dd MMM yyyy HH:mm:ss")); which should return something like: Sun 16 Nov 2008 19:15:36

But what i'm getting is: 16/11/2008 19:15:00

In my aspx.cs file i have:
List<RetrieveTravelNewsObj> returnTravelNews = getTravelNews.GetTravelNews(strDisplayMode, strDisplayFullNewsDetails);
if (returnTravelNews.Count > 0)
{
foreach (RetrieveTravelNewsObj DisplayTravelNews in returnTravelNews)
{
TravelNewsTitle.Append(DisplayTravelNews.TravelNewsTitle);
TravelNewsFull.Append(DisplayTravelNews.TravelNewsFull);
TravelNewsDateInserted.Append(DisplayTravelNews.TravelNewsDateInserted.ToString("ddd dd MMM yyyy HH:mm:ss"));
TravelNewsColumnID.Append(DisplayTravelNews.TravelNewsColumnID);
}

I have even added ("ddd dd MMM yyyy HH:mm:ss")); to the aspx.cs file but i just cannot change the date format.

Any help would be appreciated
George

Binuth

this.travelNewsDateInserted = Convert.ToDateTime(travelNewsDateInserted.ToString("ddd dd MMM yyyy HH:mm:ss"));

here you are trying to store formatted datetime string to DATETIME Datatype( i.e this.travelNewsDateInserted). datetime data type never store date somthing like "Sun 16 Nov 2008 19:15:36" , if you want to keep same format use STRING Datatype insteed of DATETIME Datatype

BeginningWebDesign

ASKER

Hi Binuth:
I'm not sure what you mean, can you give me a example
Regards
George

ASKER CERTIFIED SOLUTION

Binuth

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

BeginningWebDesign

ASKER

Hi Binuth:
Understand now, works OK thanks
Regards
George