Setting default value to a time attribute

Hello, I need to set a defualt value for a time attribute. I use the following dql:

ALTER TYPE lae_informe_60000012 MODIFY (lae_atr_fechalistado(SET default= date('05-12-2011'),SET read_only=true,SET not_null=true)) publish

But then, I check the value and is the following one:

lae_atr_fechalistado

13/04/2011 1:00:00

As you can see the month has been increased, and the day decreased...Why does this happen?? How can I set correctly the default value?

Many thanks!!

Find more posts tagged with

BPM

API

Note:

If there are Accepted Answers, those will be shown by default. You can switch to 'All Replies' by selecting the tab below.

Accepted answers

jmeabe

In the end the problem was the time zone configuration in my server. It was set to UTC time, while were I live the tz is UTC +1:00, so the system automatically subtracted one hour to every time attribute set. I solved it by setting the value of r_normal_tz attribute in dm_docbase_config object to 3600 (number of seconds of an hour to add to UTC time).

Regards.

All comments

DCTM_Guru

How/where are you seeing this value? You are probably seeing effect of timezone offset.

jmeabe

I'm trying to set it through DQL editor first, and when I get the proper dql I will do it inside a webservice code with a query execution object using the same dql.

DCTM_Guru

Are you using DQL editor within DA or repoint or DQL command line tool on Content Server. I would also be more exact in your query:

ALTER TYPE lae_informe_60000012 MODIFY (lae_atr_fechalistado(SET default= date('05-12-2011 00:00:00'),SET read_only=true,SET not_null=true)) publish

jmeabe

Regards.