<span style="font-family: courier new,monospace;">Can anyone tell me how to store a 'date/time' in a DBI::CSV file?</span><br style="font-family: courier new,monospace;"><br style="font-family: courier new,monospace;">
<span style="font-family: courier new,monospace;">ie. 01-MAY-2009 00:00:00</span><br style="font-family: courier new,monospace;"><br style="font-family: courier new,monospace;"><span style="font-family: courier new,monospace;">Because... if I use something like:</span><br style="font-family: courier new,monospace;">
<br style="font-family: courier new,monospace;"><span style="font-family: courier new,monospace;">$dateTime = "01-MAY-2009 00:00:00";</span><br style="font-family: courier new,monospace;"><span style="font-family: courier new,monospace;">INSERT INTO table (DATE) values ( '$dateTime' )</span><br style="font-family: courier new,monospace;">
<br style="font-family: courier new,monospace;"><span style="font-family: courier new,monospace;">then what's written is a quoted dateTime string:<br><br> "01-MAY-2009 00:00:00"</span><br style="font-family: courier new,monospace;">
<span style="font-family: courier new,monospace;"><br>not the value itself:<br><br> </span><span style="font-family: courier new,monospace;">01-MAY-2009 00:00:00<br><br></span><span style="font-family: courier new,monospace;"> </span><div style="display: none;" class="Af">
<div class="nH"><div style="overflow: auto;" class="nH"><textarea class="Ah nr" style="height: 36px;"></textarea></div></div><div class="Ag">Let people know what you're up to, or share links to photos, videos, and web pages.</div>
</div><div id="goog-acr-0" class="ah" style="left: 245px; top: 183px; -moz-user-select: none; display: none;"><div style="-moz-user-select: none;" id="goog-acri-149" class="ac-row"><div style="-moz-user-select: none;" class="aq">
<div style="-moz-user-select: none;" class="am"><<b style="-moz-user-select: none;" class="ac-highlighted">fulko</b>.<a href="mailto:hew@gmail.com">hew@gmail.com</a>></div></div></div><div style="-moz-user-select: none;" id="goog-acri-150" class="ac-row ac-active active">
<div style="-moz-user-select: none;" class="aq"><div style="-moz-user-select: none;" class="am">"<b style="-moz-user-select: none;" class="ac-highlighted">Fulko</b> Hew(w)" <<a href="mailto:fulko.hew@sita.aero">fulko.hew@sita.aero</a>></div>
</div></div><div style="-moz-user-select: none;" id="goog-acri-151" class="ac-row"><div style="-moz-user-select: none;" class="aq"><div style="-moz-user-select: none;" class="am">"<b style="-moz-user-select: none;" class="ac-highlighted">Fulko</b> Hew" <<a href="mailto:fhew3@cogeco.ca">fhew3@cogeco.ca</a>></div>
</div></div></div><div tabindex="-1" style="-moz-user-select: none; display: none;" class="goog-menu goog-menu-vertical ex"><div id=":1j7" style="-moz-user-select: none;" class="goog-menuitem"><div class="goog-menuitem-content">
Ignore</div></div><div id=":1j8" style="-moz-user-select: none; display: none;" class="goog-menuitem"><div class="goog-menuitem-content">Edit Word</div></div></div>