DateTime() Q.

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

I have a field that has the DATETIME() of the entry. How do I sql the
datetime field for just the date and not the time portion?

ie.
SELECT * FROM xxx WHERE between(mydatetimeField,dateStart,dateStop) INTO
TABLE ....

Respectfully,

Jonathan Morningstar


.

Relevant Pages

  • Re: Storing only timepart in Sql server datetime
    ... I'm using a DateTime field in MS SQL 2000, and by using Delphi's Frac method ... > stuck with setting up a character data type for the time portion only. ...
    (microsoft.public.dotnet.framework.adonet)
  • 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)
  • Re: Information between specific dates
    ... a dateTime field. ... After you answer that perhaps you can post the SQL view of your query. ... Access MVP 2002-2005, 2007-2008 ... Center for Health Program Development and Management ...
    (microsoft.public.access.queries)
  • Re: UPDATING/INSERTING DATETIME FIELDS FROM ASP?
    ... I think I will need to use calculations at some point, is there a way to pass the Nowvalue into the datetime field. ... I would have used the timestamp but it isn't available on my SQL server. ... Please reply to the newsgroup. ...
    (microsoft.public.inetserver.asp.db)
  • Re: Typed dataset: Time only data in SQL dateTime Field
    ... typed dataset. ... We are in the process of moving from access to Sql 2000. ... I now have 2 typed datasets one pointing to a table in access and one ... DateTime field expected to have only a time in it. ...
    (microsoft.public.dotnet.framework.adonet)