If your using a DIH you can configure it however you want. Here is a
snippet of my code. Note the DateTimeTransformer.
<dataConfig>
<dataSource type="JdbcDataSource"
name="bleh"
driver="net.sourceforge.jtds.jdbc.Driver"
url="jdbc:jtds:sqlserver://localhost;databaseName=bleh;responseBuffering=adaptive;"
user="test"
password="test"
onError="skip"/>
<document>
<entity name="Entities"
dataSource="JIEE"
transformer="DateFormatTransformer"
query = "SELECT
EntityUID AS id,
EntityType AS cat,
EntityUIDParent AS pid,
subject AS subject,
summary AS summary,
DateCreated AS eventdate,
Latitude AS lat,
Longitude AS lng,
Type AS jtype,
SupportCategory AS supcat,
Cause AS cause,
Status AS status,
Urgency AS urgency,
Priority AS priority,
Coordinate AS coords
FROM dbo.JIEESearchIndex">
<field column="id" name="id" />
<field column="cat" name="cat" />
<field column="subject" name="subject" />
<field column="summary" name="summary" />
<field column="eventdate" name="eventdate"
dateTimeFormat="yyyy-MM-dd'T'HH:mm:ss.SSS'Z'"/>
<field column="lat" name="lat" />
<field column="lng" name="lng" />
<field column="coords" name="coords" />
<field column="jtype" name="jtype" />
<field column="supcat" name="supcat" />
<field column="cause" name="cause" />
<field column="status" name="status" />
<field column="urgency" name="urgency" />
</entity>
On Wed, Feb 2, 2011 at 7:28 PM, Dennis Gearon <gear...@sbcglobal.net> wrote:
> For time of day fields, NOT unix timestamp/dates, what is the best way to do
> that?
>
> I can think of seconds since beginning of day as integer
> OR
> string
>
> Any other ideas? Assume that I'll be using range queries. TIA.
>
>
>
> Â Dennis Gearon
>
>
> Signature Warning
> ----------------
> It is always a good idea to learn from your own mistakes. It is usually a
> better
> idea to learn from others’ mistakes, so you do not have to make them yourself.
> from 'http://blogs.techrepublic.com.com/security/?p=4501&tag=nl.e036'
>
>
> EARTH has a Right To Life,
> otherwise we all die.
>
>
