<!-- 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>
<A HREF="sld038.htm">Previous</A>
<A HREF="sld040.htm">Next</A>
<A HREF="sld102.htm">Last</A>
<A HREF="index.htm">Index</A>
<A HREF="dbi.perl.org">Home</A>
<A HREF="tsld039.htm">Text</A>
</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->bind_param(1, "2004-12-31", SQL_DATE);
<BR><BR>$sth->bind_param(2, "2004-12-31 23:59:59", SQL_DATETIME);
<BR>$sth->bind_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>