On Sun, Jun 27, 2010 at 8:44 AM, Grigore Dolghin <[email protected]> wrote:
> Um.... I don't know about the vb & c# 2008, but 2010 version have the date 
> datatype:
>
> Dim x As Date = #10/5/2003#

If I understand correctly Date in vb.net is the same as DateTime in c#.
So VB & c# do not have a datatype that matches SQLs date type exactly.

It's just something to be aware of.  For example, when writing back to
the SQL database you may need to strip the time out.

-- 
Paul

> -----Original Message-----
> From: [email protected] [mailto:[email protected]] On 
> Behalf Of Paul Hill
> Sent: Sunday, June 27, 2010 3:11 AM
> To: [email protected]
> Subject: Re: Sqlserver 2005 or 2008
>
> On Sat, Jun 26, 2010 at 5:51 PM, Grigore Dolghin <[email protected]> wrote:
>> Go for Date datatype if you're using SQL Server 2008.
>
> Be aware that you may run into problems if your 'front end' language does not 
> have a date datatype!
> (like C# & VB.Net for instance)

-- 
Paul

_______________________________________________
Post Messages to: [email protected]
Subscription Maintenance: http://leafe.com/mailman/listinfo/profox
OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech
Searchable Archive: http://leafe.com/archives/search/profox
This message: 
http://leafe.com/archives/byMID/profox/[email protected]
** All postings, unless explicitly stated otherwise, are the opinions of the 
author, and do not constitute legal or medical advice. This statement is added 
to the messages for those lawyers who are too stupid to see the obvious.

Reply via email to