Convert GetSQLDateTime to formatted date to show on a Windows Form

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Andy A38 - 28 Apr 2005 13:08 GMT

I am retrieving data using ADO.Net (from SQL Server) as shown below:

DOB.Text = MyDataReader.GetSqlDateTime(18).ToString

This works fine, but I want to display this on the form formatted as "dd MMM
yyyy" rather than the way it shows now ("dd/mm/yyyy hh:nn").

How can I do this?

Signature

Andy, MCDBA

Reply to this Message

Katy King - 29 Apr 2005 19:35 GMT

From: "=?Utf-8?B?QW5keSBBMzg=?=" <AndyA38@discussions.microsoft.com>

| I am retrieving data using ADO.Net (from SQL Server) as shown below:
|
[quoted text clipped - 4 lines]
|
| How can I do this?

DateTime allows you to specify the string format. It looks like
SqlDateTime does not?
If you convert to DateTime first you can do this.

DOB.Text = MyDataReader.GetSqlDateTime(18).Value.ToString("dd MMM yyyy")

There may be a better way as well.

Katy

Reply to this Message

Free Magazines

Get these publications absolutely FREE for up to 12 months. There are no hidden fees and no obligation. Simply choose a title, complete the application form and submit it. Read more ...