Doubt Date

[Paulo]

Hi, how can I return just the date from a DateTime field ? Any C# .net 2.0 /
SQL function?

Thanks a lot!

[Mark Rae [MVP]]

"Paulo" <pr*****@uol.com.brwrote in message
news:eL**************@TK2MSFTNGP05.phx.gbl...

Hi, how can I return just the date from a DateTime field ? Any C# .net 2.0
/ SQL function?

string strDateOnly = DateTime.Now.ToString("dd MMM yyyy");
--
Mark Rae
ASP.NET MVP
http://www.markrae.net

[Paulo]

But where do I put the reader['FieldName'] returned from the SQL Server ?

"Mark Rae [MVP]" <ma**@markNOSPAMrae.netescreveu na mensagem
news:e8**************@TK2MSFTNGP06.phx.gbl...

"Paulo" <pr*****@uol.com.brwrote in message
news:eL**************@TK2MSFTNGP05.phx.gbl...

>Hi, how can I return just the date from a DateTime field ? Any C# .net
2.0 / SQL function?

string strDateOnly = DateTime.Now.ToString("dd MMM yyyy");
--
Mark Rae
ASP.NET MVP
http://www.markrae.net

[Mark Rae [MVP]]

"Paulo" <pr*****@uol.com.brwrote in message
news:%2********************@TK2MSFTNGP02.phx.gbl.. .

But where do I put the reader['FieldName'] returned from the SQL Server ?

You made no mention of a datareader in your original post...

Please explain exactly what you are trying to do...
--
Mark Rae
ASP.NET MVP
http://www.markrae.net

[Paulo]

Sorry my friend, what I need to do is return a DateTime field from SQL
Server 2000 and put it on a text box to the user edit, but when I do:

Text.text = reader['SomeField'].AsString;

shows: 06/08/2007 00:00:00

I need only: 06/08/2007 (dd/mm/aaaa) the Brasil format...

Can you understand me ?

Thanks
"Mark Rae [MVP]" <ma**@markNOSPAMrae.netescreveu na mensagem
news:uj**************@TK2MSFTNGP05.phx.gbl...

"Paulo" <pr*****@uol.com.brwrote in message
news:%2********************@TK2MSFTNGP02.phx.gbl.. .

>But where do I put the reader['FieldName'] returned from the SQL Server ?

You made no mention of a datareader in your original post...

Please explain exactly what you are trying to do...
--
Mark Rae
ASP.NET MVP
http://www.markrae.net

[Mark Rae [MVP]]

"Paulo" <pr*****@uol.com.brwrote in message
news:un**************@TK2MSFTNGP03.phx.gbl...

Sorry my friend, what I need to do is return a DateTime field from SQL
Server 2000 and put it on a text box to the user edit, but when I do:

Text.text = reader['SomeField'].AsString;

shows: 06/08/2007 00:00:00

I need only: 06/08/2007 (dd/mm/aaaa) the Brasil format...

Text.text = reader['SomeField'].ToString("dd/mm/aaaa");
--
Mark Rae
ASP.NET MVP
http://www.markrae.net

[Cowboy \(Gregory A. Beamer\)]

String.Format() should work

or load into a DateTime object and use dateTime.ToShortDateString().

The String format is useful if you are dealing with one date format. The
DateTime is better if you have to be culture aware, as it respects the
culture of the thread.

--
Gregory A. Beamer
MVP; MCP: +I, SE, SD, DBA
http://gregorybeamer.spaces.live.com
Co-author: Microsoft Expression Web Bible (upcoming)

************************************************
Think outside the box!
************************************************
"Paulo" <pr*****@uol.com.brwrote in message
news:eL**************@TK2MSFTNGP05.phx.gbl...

Hi, how can I return just the date from a DateTime field ? Any C# .net 2.0
/ SQL function?

Thanks a lot!

[Mark Rae [MVP]]

"George Ter-Saakov" <gt****@cardone.comwrote in message
news:%2****************@TK2MSFTNGP03.phx.gbl...

You got to cast ot DateTime first
Text.text = ((DateTime)reader['SomeField']).ToString("dd/mm/aaaa");

D'oh! Apologies, everybody... :-(
--
Mark Rae
ASP.NET MVP
http://www.markrae.net