The Perl Toolchain Summit needs more sponsors. If your company depends on Perl, please support this very important event.

<!--  Presentation generated by Internet Assistant for Microsoft PowerPoint 97 -->

<HTML>
<HEAD>

<meta name="GENERATOR" content="Microsoft Internet Assistant for Microsoft PowerPoint 97">
 <TITLE>Got TIME for a DATE?</TITLE> 
</HEAD>

<BODY     >

<CENTER>
<TABLE WIDTH=100%> 
     <TR> <TD WIDTH=100% ALIGN=CENTER>
         <A HREF="sld001.htm">First</A>&nbsp;&nbsp;
         <A HREF="sld038.htm">Previous</A>&nbsp;&nbsp;
         <A HREF="sld040.htm">Next</A>&nbsp;&nbsp;
         <A HREF="sld102.htm">Last</A>&nbsp;&nbsp;
&nbsp;&nbsp;         <A HREF="index.htm">Index</A>&nbsp;&nbsp;
         <A HREF="dbi.perl.org">Home</A>&nbsp;&nbsp;
         <A HREF="tsld039.htm">Text</A>&nbsp;&nbsp;
     </TD> </TR>
     <TR> <TD WIDTH=100% ALIGN=CENTER>
         <IMG SRC="img039.gif" usemap="#Objmap" WIDTH=800 HEIGHT=600 BORDER=0>
     </TD> </TR>
</TABLE>
<P>Slide 39 of 102</P>
</CENTER>
<!-- <UL>
<H2>Got TIME for a DATE?</H2>
</UL></P>
<P><UL>
<LI><H2>Date and time types are strings in the native database format
</H2>
<UL>
<LI>many valid formats, some incompatible or ambiguous 'MM/DD/YYYY' vs 'DD/MM/YYYY'
<UL>
<LI>
</UL></UL></UL><UL>
<LI><H2>Obvious need for a common format
</H2>
<UL>
<LI>The SQL standard (ISO 9075) uses 'YYYY-MM-DD' and 'YYYY-MM-DD HH:MM:SS'
<UL>
<LI>
</UL></UL></UL><UL>
<LI><H2>DBI now says using a date/time TYPE mandates ISO 9075 format
</H2>
<UL>
$sth-&#062bind_param(1, "2004-12-31", SQL_DATE);
<BR><BR>$sth-&#062bind_param(2, "2004-12-31 23:59:59", SQL_DATETIME);
<BR>$sth-&#062bind_col(1, \$foo, SQL_DATETIME); # for selecting data
<BR>
</UL></UL><UL>
<LI><H2>Driver is expected to convert to/from native database format
</H2>
<UL>
<LI>New feature, as of DBI 1.43, not yet widely supported
</UL></UL><UL>
<LI><H2>
</H2>
</UL><UL>
<H2>.</H2>
</UL></P>
<P>  -->
</Body>
</HTML>