dates/times are stored internally in database fields in compressed format, and SQL select statements do the translation for you, even displaying in locally set display variation. No such shortcut for insertion/update though. you'll need to find out the name of the specific ToDate or ToTime function of your specific database engine. each database engine (oracle, mysql, mssql, etc.) stores and handles dates/times differently, and have their own function to handle such. an example insert for a ficticious database engine would be something like
insert into this_table (ToDate("17-07-2007");

[download]
of course the actual format of the date you pass in is database engine specific, using particular delimiters and honoring (or not) your locale setting for date display.
the hardest line to type correctly is: stty erase ^H

In reply to Re: SQL Insert Statement for date by aquarium
in thread SQL Insert Statement for date by phimtau123

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.