I figured it out. I use SQL Server, so this is my solution :
<propertyWriter dateFormat="*yyyy-MM-dd'T'HH:mm:ssXXX*"
type="SimplePropertiesWriter" />
In TSQL, this can be converted to a UTC date time using :
CONVERT(datetimeoffset, '${dih.last_index_time}', 127)
Refs:
http://docs.oracle.com/javase/7/docs/api/java/text/SimpleDateFormat.html
http://msdn.microsoft.com/en-us/library/ms187928.aspx
On Thu, Mar 27, 2014 at 2:17 PM, Kiran J <kiranjuni...@gmail.com> wrote:
> Thank you for the response. This works if I invoke start.jar with java. In
> my usecase however, I need to invoke start.jar directly (consoleless
> service so that the user cannot close it accidentally). It doesnt pickup
> user.timezone property when done this way. Is it possible to do this using
> the tag below somehow. I tried setting locale="UTC" and it didnt work.
>
> <propertyWriter dateFormat="yyyy-MM-dd HH:mm:ss"
> type="SimplePropertiesWriter" directory="data" filename="my_dih.properties"
> locale="en_US" />
>
>
>
> On Tue, Mar 25, 2014 at 7:45 PM, Gora Mohanty <g...@mimirtech.com> wrote:
>
>> On 26 March 2014 02:44, Kiran J <kiranjuni...@gmail.com> wrote:
>> >
>> > Hi
>> >
>> > Is it possible to set up the data import handler so that it keeps track
>> of
>> > the last imported time in Zulu time and not local time ?
>> [...]
>>
>> Start your JVM with the desired timezone, e.g.,
>> java -Duser.timezone=UTC -jar start.jar
>>
>> Regards,
>> Gora
>>
>
>
