<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD><TITLE>Message</TITLE>
<META http-equiv=Content-Type content="text/html; charset=us-ascii">
<META content="MSHTML 6.00.2900.2604" name=GENERATOR></HEAD>
<BODY>
<DIV><SPAN class=605334220-17102005><FONT face=Arial color=#0000ff size=2>FYI, I
solved this problem using Oracle's TO_CHAR() function.</FONT></SPAN></DIV>
<DIV><SPAN class=605334220-17102005><FONT face=Arial color=#0000ff
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=605334220-17102005><FONT face=Arial color=#0000ff
size=2>-e</FONT></SPAN></DIV>
<BLOCKQUOTE dir=ltr style="MARGIN-RIGHT: 0px">
<DIV></DIV>
<DIV class=OutlookMessageHeader lang=en-us dir=ltr align=left><FONT
face=Tahoma size=2>-----Original Message-----<BR><B>From:</B>
gdal-dev-bounces@lists.maptools.org
[mailto:gdal-dev-bounces@lists.maptools.org] <B>On Behalf Of </B>Ethan
Alpert<BR><B>Sent:</B> Tuesday, October 11, 2005 11:35 AM<BR><B>To:</B>
gdal-dev@lists.maptools.org<BR><B>Subject:</B> [Gdal-dev] OGR and Oracle DATE
and TIMESTAMP fields?<BR><BR></FONT></DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><SPAN class=944443317-11102005><FONT face=Arial size=2>I'm using OGR's
ExecuteSQL() datasource method and it appears DATE and TIMESTAMP fields are
ignored. Anyone know how to get dates out or oracle using OGR without having
to open a second connection to the DB using DBI?</FONT></SPAN></DIV>
<DIV><SPAN class=944443317-11102005><FONT face=Arial
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=944443317-11102005><FONT face=Arial
size=2>-e</FONT></SPAN></DIV></BLOCKQUOTE></BODY></HTML>