Re: Searching on DATETIME Fields
From: Keith (_at_.)
Date: 03/19/04
- Next message: Jerry: "Tuning Sql Server"
- Previous message: Dan Guzman: "Re: Searching on DATETIME Fields"
- In reply to: Tibor Karaszi: "Re: Searching on DATETIME Fields"
- Next in thread: Dan Guzman: "Re: Searching on DATETIME Fields"
- Messages sorted by: [ date ] [ thread ]
Date: Fri, 19 Mar 2004 14:44:24 -0000
Thank you
"Tibor Karaszi" <tibor_please.no.email_karaszi@hotmail.nomail.com> wrote in
message news:uCoIaAcDEHA.3836@TK2MSFTNGP09.phx.gbl...
> Please check the article again. The datetime datatype does not store the
> values in any readable format. The format you see is created by the
> application with which you look at the data.
>
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
>
>
> "Keith" <@.> wrote in message
news:eesLa4bDEHA.3584@TK2MSFTNGP11.phx.gbl...
> > I have seen that before, but my question is, why would passing
19/03/2004
> > 00:00:00 to a field of type datetime, which does contain values in this
> > format, fail?
> >
> > Surely passing the value is all that is required regardless of the
> datatype
> > as long as it matches the data contained in the field?
> >
> > "Tibor Karaszi" <tibor_please.no.email_karaszi@hotmail.nomail.com> wrote
> in
> > message news:eemPg0bDEHA.688@tk2msftngp13.phx.gbl...
> > > All you need at:
> > >
> > > http://www.karaszi.com/sqlserver/info_datetime.asp
> > >
> > > --
> > > Tibor Karaszi, SQL Server MVP
> > > http://www.karaszi.com/sqlserver/default.asp
> > >
> > >
> > > "Keith" <@.> wrote in message
> > news:uqwYixbDEHA.1544@TK2MSFTNGP09.phx.gbl...
> > > > I am fairly new to SQL so sorry if this is a really dumb question.
> > > >
> > > > I have a small (still) SQL database, which I am trying to query from
> an
> > > ASP
> > > > page.
> > > >
> > > > The field I am querying is of DATETIME data type, and is populated
> > > > automatically using the GetDate() function as a default value.
> > > >
> > > > When I try and search on this field, using a date/time in the format
> > > > dd/mm/yyyy hh:mm:ss as the search criteria, it fails with the
> following
> > > > error:
> > > >
> > > > [Microsoft][ODBC SQL Server Driver][SQL Server]The conversion of a
> char
> > > data
> > > > type to a datetime data type resulted in an out-of-range datetime
> value.
> > > >
> > > > Can anyone tell me why this is? Surely if I am passing a value in
the
> > > > correct format for the data stored in the field it should work? Or
am
> I
> > > > missing something.
> > > >
> > > >
> > >
> > >
> >
> >
>
>
- Next message: Jerry: "Tuning Sql Server"
- Previous message: Dan Guzman: "Re: Searching on DATETIME Fields"
- In reply to: Tibor Karaszi: "Re: Searching on DATETIME Fields"
- Next in thread: Dan Guzman: "Re: Searching on DATETIME Fields"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
