When dealing with dates in databases (and generally, too), you will profit a lot from using the representation commonly known as ISO Date Format, described in more detail in ISO 8601:1988 Date/Time Representations (Note that this is only a description of the standard, not the standard itself (for which the copyright is held by the ISO)), which is commonly used in the two forms 'YYYYMMDD' and 'YYYY-MM-DD', where Y is a year digit, M is a month digit, and D is a day digit. Access will recognize and autoconvert the first form without problems, as will MS SQL Server and Sybase.

This form of representation has numerous advantages, not the least being that you can sort dates represented like that by a simple string comparison sort.

Much more nice info on dates is available in a very compact form at J. R. Stockton's Date Formats page.

Christian Lemburg
Brainbench MVP for Perl
http://www.brainbench.com

In reply to Re: Database time or just time by clemburg
in thread Database time or just time by Kiko

Title:
Use:  <p> text here (a paragraph) </p>
and:  <code> code here </code>
to format your post, it's "PerlMonks-approved HTML":


  • Posts are HTML formatted. Put <p> </p> tags around your paragraphs. Put <code> </code> tags around your code and data!
  • Titles consisting of a single word are discouraged, and in most cases are disallowed outright.
  • Read Where should I post X? if you're not absolutely sure you're posting in the right place.
  • Please read these before you post! —
  • Posts may use any of the Perl Monks Approved HTML tags:
    a, abbr, b, big, blockquote, br, caption, center, col, colgroup, dd, del, details, div, dl, dt, em, font, h1, h2, h3, h4, h5, h6, hr, i, ins, li, ol, p, pre, readmore, small, span, spoiler, strike, strong, sub, summary, sup, table, tbody, td, tfoot, th, thead, tr, tt, u, ul, wbr
  • You may need to use entities for some characters, as follows. (Exception: Within code tags, you can put the characters literally.)
            For:     Use:
    & &amp;
    < &lt;
    > &gt;
    [ &#91;
    ] &#93;
  • Link using PerlMonks shortcuts! What shortcuts can I use for linking?
  • See Writeup Formatting Tips and other pages linked from there for more info.