Time fields

classic Classic list List threaded Threaded
2 messages Options
Reply | Threaded
Open this post in threaded view
|

Time fields

gearond
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.

Reply | Threaded
Open this post in threaded view
|

Re: Time fields

Adam Estrada-2
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 <[hidden email]> 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.
>
>