Re: Date format for SQL Server

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

From: Jeff Johnson [MVP: VB] (i.get_at_enough.spam)
Date: 10/25/04 

Date: Mon, 25 Oct 2004 13:24:40 -0400

"Newbie" <noidea@nospam.com> wrote in message
news:uaDPVmquEHA.1452@TK2MSFTNGP11.phx.gbl...

>I have a stored procedure in SQL Server that requires a date parameter.
>
> I have a 2 public variables (Date Type) that give a datefrom and a dateto.
> The datefrom and dateto are derived using DateSerial.
>
> I believe that SQL needs the dates in "mm/dd/yyyy" format but the
> variables
> are in "dd/mm/yyyy" format. How can I change this?

If the parameter is defined as a date (adDate if you're using ADO) and you
have a real Date variable, simply assign that variable directly to the
parameter; no conversion necessary. In fact, it's the conversion that's the
source of your troubles, as you're trying to assign a string to a date.

Relevant Pages

  • Re: Date format for SQL Server
    ... SQL Query Analyser records are returned. ... >> The datefrom and dateto are derived using DateSerial. ... > If the parameter is defined as a date (adDate if you're using ADO) and you ...
    (microsoft.public.vb.syntax)
  • Re: Datumsdifferenz o. Samstage u. Sonntage
    ... Dim i As Long, j As Long ... Public Function countWeekDays(DateFrom As Date, DateTo As Date) As Long ... If DateFrom> DateTo Then ...
    (microsoft.public.de.access)
  • RE: Finding the amount of days between two dates.
    ... "NateBuckley" wrote: ... "Mike H" wrote: ... DateFrom = 01/04/08 ... DateTo = 04/04/08 ...
    (microsoft.public.excel.programming)
  • RE: Finding the amount of days between two dates.
    ... "NateBuckley" wrote: ... life of me I can't figure this out. ... DateFrom = 01/04/08 ... DateTo = 04/04/08 ...
    (microsoft.public.excel.programming)
  • Re: The original version
    ... One of the fundamental principles of Anchor Modeling is that it is ... based on DateFrom for the new attribute’s value. ... There is no DateTo. ... Regarding history of databases this is logical nonsense. ...
    (comp.databases.theory)