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=-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=4501tag=nl.e036'
EARTH has a Right To Life,
otherwise we all die.