date + 1 ???

Hi group,

Using Oracle, and given that $date=30/01/2006, you can construct a query as
follows:

select * from table
where date_field between to_date('$date', 'dd/mm/yyyy') and to_date('$date',
'dd/mm/yyyy')+1

What is the equivalent with MSSQL?

Thanks,

Edward


.

Relevant Pages

  • optimizing subqueries with in operator
    ... The problem is that this query is terribly slow. ... rows this query takes more than one minute on MSsql while on Oracle after ... optimizing it takes 0,1 seconds! ...
    (microsoft.public.sqlserver.programming)
  • Non-Visual Query Builder Component
    ... I have seen many visual components, however, I am looking for non-visual ... component that will take the parts and build the query. ... Oracle and MSSQL. ...
    (borland.public.delphi.thirdpartytools.general)
  • Re: Views - performance
    ... when u use stored object views oracle has to read the data dictionary ... this includes lots of steps for execution ... semantics of the query and fires it ... you'll possibly have any idea is to use explain plan to provide a base ...
    (comp.databases.oracle.server)
  • RE: DBI-1.48 bind_param_inout produces ORA-01461 colliding with a CLOB
    ... can pass strings as varchar's and have them inserted ... In theory I could write something to query the ... CLOB w/in Oracle is probably what is killing me... ...
    (perl.dbi.users)
  • Re: Equilevant of Oracle for optional records
    ... and a normalized t2 could be more useful, to build the query, and once this ... the Iqaluit Trauma: ... Oracle handles this data structure perfectly but I suspect it might be ...
    (microsoft.public.access.queries)