Simple DateTime sql query

Question

How do I query DateTime database field within a certain range   I am using SQL SERVER 2005  Error code below  SELECT      FROM TABLENAME   WHERE DateTime  gt   12 04 2011 12 00 00 AM     AND DateTime  lt   25 05 2011 3 53 04 AM   Note that I need to get rows within a certain time range   Example  10 mins time range   Currently SQL return with Incorrect syntax near  12

User · Answer

You need quotes around the string you re trying to pass off as a date  and you can also use BETWEEN here    SELECT      FROM TABLENAME   WHERE DateTime BETWEEN  04 12 2011 12 00 00 AM  AND  05 25 2011 3 53 04 AM    See answer to the following question for examples on how to explicitly convert strings to dates while specifying the format   Sql Server string to date conversion

User · Answer

select getdate    O P ---- 2011-05-25 17 29 44 763  select convert varchar 30  getdate   131   gt    12 04 2011 12 00 00 AM   O P --- 22 06 1432  5 29 44 763PM

User · Answer

You can execute below code  SELECT Time FROM  TableName  where DATEPART YYYY  Time    2018  and DATEPART MM  Time    06  and DATEPART DD  Time    14

User · Answer

You missed single quote sign   SELECT    FROM TABLENAME  WHERE DateTime  gt    12 04 2011 12 00 00 AM  AND DateTime  lt    25 05 2011 3 53 04 AM    Also  it is recommended to use ISO8601 format YYYY-MM-DDThh mm ss nnn  Z    as this one will not depend on your server s local culture   SELECT   FROM TABLENAME  WHERE      DateTime  gt    2011-04-12T00 00 00 000  AND      DateTime  lt    2011-05-25T03 53 04 000

User · Answer

Others have already said that date literals in SQL Server require being surrounded with single quotes  but I wanted to add that you can solve your month day mixup problem two ways  that is  the problem where 25 is seen as the month and 5 the day      Use an explicit Convert datetime   datevalue   style  where style is one of the numeric style codes  see Cast and Convert  The style parameter isn t just for converting dates to strings but also for determining how strings are parsed to dates  Use a region-independent format for dates stored as strings  The one I use is  yyyymmdd hh mm ss   or consider ISO format  yyyy-mm-ddThh mi ss mmm  Based on experimentation  there are NO other language-invariant format string   Though I think you can include time zone at the end  see the above link

User · Answer

This has worked for me in both SQL Server 2005 and 2008   SELECT   from TABLE WHERE FIELDNAME  gt   ts  2013-02-01 15 00 00 001     AND FIELDNAME  lt   ts  2013-08-05 00 00 00 000

User · Answer

Open up the Access File you are trying to export SQL data to  Delete any Queries that are there  Everytime you run SQL Server Import wizard  even if it fails  it creates a Query in the Access DB that has to be deleted before you can run the SQL export Wizard again

User · Answer

SELECT      FROM TABLENAME   WHERE  DateTime   gt    2011-04-12 12 00 00 AM     AND  DateTime   lt    2011-05-25 3 35 04 AM    If this doesn t work  please script out your table and post it here  this will help us get you the correct answer quickly

[sql] Simple DateTime sql query

Examples related to sql

Examples related to sql-server

Examples related to sql-server-2005

Examples related to tsql

Examples related to sql-server-2008