Re: Problems with querying date field

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

From: Tibor Karaszi (tibor_please.no.email_karaszi_at_hotmail.nomail.com)
Date: 03/30/04 

Date: Tue, 30 Mar 2004 10:57:20 +0200

Your question is already answered, but you might want to read below, which has some tips etc on working with
the datetime datatypes:

http://www.karaszi.com/sqlserver/info_datetime.asp 

-- 
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
"Eddie" <anonymous@discussions.microsoft.com> wrote in message
news:EB986181-6524-4983-B4AC-A3C7B40F5D17@microsoft.com...
> Hi there,
> I have a sql table with a datetime field. I am having real difficulty querying to that table using  a data.
The format of the date in the field is in the format  '2004-03-29 15:32:00.000'
>
> When I try this qurey I get an error
> SELECT     *
> FROM         Actions
> where ActionDate = '2004-03-29 %'
>
> What do I need to do for this to work, can anyone help out???
>
> regards, Eddie.
>

Relevant Pages

  • Re: Typed dataset: Time only data in SQL dateTime Field
    ... I can type in a Time alone directly into a sql DateTime field. ... I need to retain the format as it was in access. ... how be able to provide input to my typed dataset to replicate the behavior. ... I also noticed that the Sql import was able to replicate this format. ...
    (microsoft.public.dotnet.framework.adonet)
  • Problems with querying date field
    ... I have a sql table with a datetime field. ... I am having real difficulty querying to that table using a data. ... The format of the date in the field is in the format '2004-03-29 15:32:00.000' ...
    (microsoft.public.sqlserver.programming)
  • Re: converting date format on for xml query
    ... >im trying to get the datetime field that on my sql is on ... >but on xml it shows me this ... >>mapped to an ISO format. ...
    (microsoft.public.sqlserver.xml)
  • Re: converting date format on for xml query
    ... im trying to get the datetime field that on my sql is on ... but on xml it shows me this ... >mapped to an ISO format. ...
    (microsoft.public.sqlserver.xml)
  • Re: Inserting regional settings specific data into sql server
    ... All EU countries withouth the two English speaking use the format dd-MM-yy ... By using the parameters, while the program is in the right culture setting, ... than all those formats results using SQLparameters in the way the SQL server ...
    (microsoft.public.dotnet.framework.adonet)