Re: Date extraction

Tech-Archive recommends: Fix windows errors by optimizing your registry

"Luiz Horacio" <lhoracio@xxxxxxxxx> wrote in message
news:%23MIACjnoHHA.3264@xxxxxxxxxxxxxxxxxxxxxxx

One (in fact two) stupid questions. I have a date/time field in a
database. Data is, of course, saved as '2007-05-30 01:55:35' format. I
have some queries that include this field, and can't find a clean way to
work with it.

If this is a true date field then data is NOT stored with ANY format.
Formats are for display, which is to say, formats are for strings. Numbers
are numbers are numbers are numbers.

2. Can I work with date part so a query like "... Where AdmDate between
'2007-05-28' and '2007-05-30' And..." will work without the need to add
hours and minutes (like "... Where AdmDate between '2007-05-28 00:00:00'
and '2007-05-30 23:59:59' And...")?

Nope. It's just a fact of life. You'd think after so many iterations of SQL
Server and the like that there would be built-in functions for this but
there aren't. We all have to tack on the 11:59:59 PM, so welcome to the
club.


.

Relevant Pages

  • deleting formatting or file history from a word doc
    ... fonts, formats, etc to clean the file? ... I don't to retype the whole file. ... in the past we have used "track changes" ...
    (microsoft.public.word.docmanagement)
  • Re: How do I deal with a "Too many different cell formats".
    ... XL: Error Message: Too Many Different Cell Formats ... they clean it up and save it there. ... Paul Gauci wrote: ...
    (microsoft.public.excel.misc)
  • Re: Too many different cell formats
    ... Some people have used OpenOffice to open the workbook, clean up some of the ... formats, save it as a new name. ... Then excel can work with it better. ... > consistent gives me the same error message. ...
    (microsoft.public.excel.misc)
  • Re: retaining ACCESS-formatted text in VISIO?
    ... mask formats them for IP decimal notation. ... Various queries pull the data ... When it apppears in the External Data window it is no longer ...
    (microsoft.public.visio.general)
  • Re: Show what forms and reports are linked to a query
    ... I am unfamiliar with some of the formats here and wasn't sure where ... "Rick B" wrote: ... I want to clean up the database. ... >> show what queries are linked to what forms and reports or are within other ...
    (microsoft.public.access.tablesdbdesign)