How to trim off the time part of a DateTime field

[ad]

I have a tabls of SQL 2000, about the data of student.
The data is migrate from another databse,
There is a field called birthday, it stores the data with the formate like:
1994/11/03 AM 02:09:00

When I bind the field to datagrid, how can I suppress the time part , or
how can I trim the time part form database?

[Fred Chan]

you can use the CONVERT function in sql

try this:

CONVERT(varchar(20), Getdate(), 103)

"ad" <[e-mail]> wrote in message
news:%2****************@TK2MSFTNGP09.phx.gbl...

I have a tabls of SQL 2000, about the data of student.
The data is migrate from another databse,
There is a field called birthday, it stores the data with the formate
like:
1994/11/03 AM 02:09:00

When I bind the field to datagrid, how can I suppress the time part , or
how can I trim the time part form database?

[mavisahdas]

Hi Kent,

You can make use form Data Format string property of the grid columns to
format the date.

For more input Refer http://www.dotnetspider.com/technology/kbpages/384.aspx.

With regards,

Sadha Sivam S,
Microsoft Community Star,
Sr. Engineer,
Aspire Systems,
www.dotnetspider.com

"ad" wrote:

I have a tabls of SQL 2000, about the data of student.
The data is migrate from another databse,
There is a field called birthday, it stores the data with the formate like:
1994/11/03 AM 02:09:00

When I bind the field to datagrid, how can I suppress the time part , or
how can I trim the time part form database?

[ural]

If it is only for display purpose you can use this
Datime objDt = new datetime.now
objDt.ToString("MMM dd yyyy");

For any other purpose, you don't really need to do conversion.
[See DateTime.ToString in MSDN]

Ural

"mavisahdas" wrote:

Hi Kent,

You can make use form Data Format string property of the grid columns to
format the date.

For more input Refer http://www.dotnetspider.com/technology/kbpages/384.aspx.

With regards,

Sadha Sivam S,
Microsoft Community Star,
Sr. Engineer,
Aspire Systems,
www.dotnetspider.com

"ad" wrote:

I have a tabls of SQL 2000, about the data of student.
The data is migrate from another databse,
There is a field called birthday, it stores the data with the formate like:
1994/11/03 AM 02:09:00

When I bind the field to datagrid, how can I suppress the time part , or
how can I trim the time part form database?

[ad]

Thank,
But I don't just for desplay purpose.
I want to really trim off the time part of that field in database.

Could somebody tell me how to do?
"ural" <ur**@discussions.microsoft.com> ¼¶¼g©ó¶l¥ó·s»D
:46**********************************@microsoft.co m...

If it is only for display purpose you can use this
Datime objDt = new datetime.now
objDt.ToString("MMM dd yyyy");

For any other purpose, you don't really need to do conversion.
[See DateTime.ToString in MSDN]

Ural

"mavisahdas" wrote:

Hi Kent,

You can make use form Data Format string property of the grid columns to
format the date.

For more input Refer http://www.dotnetspider.com/technology/kbpages/384.aspx.
With regards,

Sadha Sivam S,
Microsoft Community Star,
Sr. Engineer,
Aspire Systems,
www.dotnetspider.com

"ad" wrote:

I have a tabls of SQL 2000, about the data of student.
The data is migrate from another databse,
There is a field called birthday, it stores the data with the formate like: 1994/11/03 AM 02:09:00

When I bind the field to datagrid, how can I suppress the time part , or how can I trim the time part form database?

[Scott Allen]

Hi ad:

You can use CONVERT, as suggested ealier. The datetime datatype in SQL
will always store a time, however, even if the time is always 12:00
AM. SQL 2005 as far as I know dropped support for unique date and time
datatypes. The only other real choice is to just store a date as
varchar or nvarchar.

--
Scott
http://www.OdeToCode.com/blogs/scott/

On Wed, 4 May 2005 20:00:57 +0800, "ad" <[e-mail]> wrote:

Thank,
But I don't just for desplay purpose.
I want to really trim off the time part of that field in database.

Could somebody tell me how to do?
"ural" <ur**@discussions.microsoft.com> ¼¶¼g©ó¶l¥ó·s»D
:46**********************************@microsoft.c om...

If it is only for display purpose you can use this
Datime objDt = new datetime.now
objDt.ToString("MMM dd yyyy");

For any other purpose, you don't really need to do conversion.
[See DateTime.ToString in MSDN]

Ural

"mavisahdas" wrote:

> Hi Kent,
>
> You can make use form Data Format string property of the grid columns to
> format the date.
>
> For more input Referhttp://www.dotnetspider.com/technology/kbpages/384.aspx. >
> With regards,
>
> Sadha Sivam S,
> Microsoft Community Star,
> Sr. Engineer,
> Aspire Systems,
> www.dotnetspider.com
>
>
>
> "ad" wrote:
>
> > I have a tabls of SQL 2000, about the data of student.
> > The data is migrate from another databse,
> > There is a field called birthday, it stores the data with the formatelike: > > 1994/11/03 AM 02:09:00
> >
> > When I bind the field to datagrid, how can I suppress the time part ,or > > how can I trim the time part form database?
> >
> >
> >