Re: Inserting date datatypes via ado.net

Tech-Archive recommends: Speed Up your PC by fixing your registry

From: J. Muenchbourg (anonymous_at_dex.com)
Date: 07/01/04 

Date: Thu, 01 Jul 2004 10:36:26 -0700

I get the same exact "Syntax error converting datetime from character
string" with >
cmd.Parameters.Add(New SQLParameter("@thedate",
Convert.ToDateTime(thedate.text)))

The date format I am using for 'thedate' is mm/dd/yyyy . Do I have to
explicitly use a format function to enter it as this?

*** Sent via Devdex http://www.devdex.com ***
Don't just participate in USENET...get rewarded for it!

Relevant Pages

  • Re: Date Conversion
    ... I recommend making a string of it MM/DD/YYYY: ... >converts dates to a text data field in the format of ... >How can I convert the text data into a date format in ...
    (microsoft.public.access.queries)
  • Re: dates in query HELP PLEASE!
    ... Regardless of what your regional settings have the short date format set to, ... date to mm/dd/yyyy format if that makes sense. ... > Then I append the where string to the rest of the SQL string, in order to> run it later. ...
    (microsoft.public.access.forms)
  • datagrid sort Date column as string
    ... I got a column in datagid with 'mm/dd/yyyy' date format ... The problem is that this column is sorted as string that make: ...
    (microsoft.public.dotnet.framework.aspnet.datagridcontrol)
  • Re: Date format detection
    ... Specifies the locale for which the date string is to be formatted. ... date format for this locale. ... the system default-date format for the specified locale. ... be enclosed within single quotation marks in the date format picture. ...
    (borland.public.delphi.thirdpartytools.general)
  • Re: Date format detection
    ... > Specifies the locale for which the date string is to be formatted. ... > date format for this locale. ... > the system default-date format for the specified locale. ... > be enclosed within single quotation marks in the date format picture. ...
    (borland.public.delphi.thirdpartytools.general)