Re: SQL with Dates

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

In article <7a2bf0ea-cb77-4a32-9dcc-
0bfceab98c1e@xxxxxxxxxxxxxxxxxxxxxxxxxxx>, thomas@xxxxxxxxxxxxxxxxx
says...
Thanks for the quick replies, i will try when i get home,

question to clarify, does that mean, all date formats have to be in
yyyy/mm/dd format.

That should be "-" between the sections, not "/".

Keep in mind that the display you see of a date field generally has
nothing to do with how it's stored internally. The only time you should
need to format your dates with 'yyyy-mm-dd' is when you are trying to
compare literal dates (in a query, etc) to data stored in the date
field. If you are comparing one date field to another, you can compare
them directly.


The application references a ODBC connection from a MYOB data file.

also can you help, i want to use a textbox to provide the date
intially how do i handle this.

Thanks guys.


--
Remove the ns_ from if replying by e-mail (but keep posts in the
newsgroups if possible).
.

Relevant Pages

  • Re: Leading zeroes, text/numbers, import/export
    ... >If I want to do arithmetic, use a numeric format. ... >> We import into Excel and sometimes later export to ... >> can compare them from one list or sheet to another, ... Then, when comparing to other lists or exporting, ...
    (microsoft.public.excel.misc)
  • Re: Help with comparing date stamp in PHP to date AND time stamp coming from MYSQL db!!!!!!
    ... the time limitation to pull the username out of the DB. ... date formats and how to compare them for my little script. ... So when the user logs in again, ... So I can't change the date format ...
    (comp.lang.php)
  • Re: Q: When 0 <> 0 ?
    ... taking the IEEE floating-point format into account, ... I think the answer goes beyond the IEEE FP format to the ... and never compare two FP results ...
    (microsoft.public.excel)
  • Re: Help with comparing date stamp in PHP to date AND time stamp coming from MYSQL db!!!!!!
    ... the time limitation to pull the username out of the DB. ... date formats and how to compare them for my little script. ... So when the user logs in again, ... So I can't change the date format ...
    (comp.lang.php)
  • RE: Date Compare
    ... compare the date/time in the two text fields. ... better means to compare them(the string format), ... There does exists an Date class(javascript class object) which has parse ...
    (microsoft.public.dotnet.framework.aspnet)