SQL 2000 Date Problem

[Matthew Speed]

(Sorry if this stuff is easy. I am still a VB.Net semi-newbie)

I have a VB.Net program that retrieves dates from a SQL 2000 database.
Although I am sending over a varchar (I actually do a conversion
before I send) from SQL Server it still "sees" the data as a datetime
value. How can I make it see "6/23/2003" as 9 random characters?

[Mary Chipman]

Re: SQL 2000 Date Problem

See "Converting datetime and smalldatetime Data" in SQL Books Online.

-- Mary
MCW Technologies

http://www.mcwtech.com

On Tue, 08 Jul 2003 12:39:16 -0400, Matthew Speed <mspeed@mspeed. net>
wrote:
[color=blue]
>(Sorry if this stuff is easy. I am still a VB.Net semi-newbie)
>
>I have a VB.Net program that retrieves dates from a SQL 2000 database.
>Although I am sending over a varchar (I actually do a conversion
>before I send) from SQL Server it still "sees" the data as a datetime
>value. How can I make it see "6/23/2003" as 9 random characters?[/color]