How to resolve date issue

Hi All,

<span style="background-color: rgb(255, 255, 255); font-family: 'Segoe UI', 'Lucida Grande', Verdana, Arial, Helvetica, sans-serif; " mcestyle="background-color: #ffffff; font-family: 'Segoe UI', 'Lucida Grande', Verdana, Arial, Helvetica, sans-serif;">select DATE('5/18/2012 12:30:00 PM') from dm_server_config. <span style="background-color: rgb(255, 255, 255); font-family: 'Segoe UI', 'Lucida Grande', Verdana, Arial, Helvetica, sans-serif; " mcestyle="background-color: #ffffff; font-family: 'Segoe UI', 'Lucida Grande', Verdana, Arial, Helvetica, sans-serif;">Am using this query in one content server mechine. This is giving out put as <span class="defaultLabelStyle" style="font-family: 'Segoe UI', 'Lucida Grande', Verdana, Arial, Helvetica, sans-serif; " mcestyle="font-family: 'Segoe UI', 'Lucida Grande', Verdana, Arial, Helvetica, sans-serif;">5/19/2012 1:00 AM<span style="background-color: rgb(255, 255, 255); font-family: 'Segoe UI', 'Lucida Grande', Verdana, Arial, Helvetica, sans-serif; " mcestyle="background-color: #ffffff; font-family: 'Segoe UI', 'Lucida Grande', Verdana, Arial, Helvetica, sans-serif;"> in one mechhine. <span style="background-color: rgb(255, 255, 255); font-family: 'Segoe UI', 'Lucida Grande', Verdana, Arial, Helvetica, sans-serif; " mcestyle="background-color: #ffffff; font-family: 'Segoe UI', 'Lucida Grande', Verdana, Arial, Helvetica, sans-serif;">In one more mechine am running the same query it is giveing out put like <span class="defaultLabelStyle" style="font-family: 'Segoe UI', 'Lucida Grande', Verdana, Arial, Helvetica, sans-serif; " mcestyle="font-family: 'Segoe UI', 'Lucida Grande', Verdana, Arial, Helvetica, sans-serif;">5/18/2012 12:30 PM.

<span class="defaultLabelStyle" style="font-family: 'Segoe UI', 'Lucida Grande', Verdana, Arial, Helvetica, sans-serif; " mcestyle="font-family: 'Segoe UI', 'Lucida Grande', Verdana, Arial, Helvetica, sans-serif;">Both the mechines() are in same time zone. if any body have idea?



<span class="defaultLabelStyle" style="font-family: 'Segoe UI', 'Lucida Grande', Verdana, Arial, Helvetica, sans-serif; " mcestyle="font-family: 'Segoe UI', 'Lucida Grande', Verdana, Arial, Helvetica, sans-serif;">Thanks<span class="defaultLabelStyle" style="font-family: 'Segoe UI', 'Lucida Grande', Verdana, Arial, Helvetica, sans-serif; " mcestyle="font-family: 'Segoe UI', 'Lucida Grande', Verdana, Arial, Helvetica, sans-serif;">Raju.P

Find more posts tagged with

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

raju.pingili@intueorinfotech.com

Hi Johnny,

we are using two different content servers those are not sharing same repository. and we resloved this by using the fallowing querys

Select r_normal_tz from dm_docbase_config

Update dm_docbase_config objects set r_normal_tz = -18000

Thanks

Raju.P

All comments

raju.pingili@intueorinfotech.com

Hi All,

select DATE('5/18/2012 12:30:00 PM') from dm_server_config.

Am using this query in one content server mechine. This is giving out put as 5/19/2012 1:00 AM in one mechhine.

In one more mechine am running the same query it is giveing out put like 5/18/2012 12:30 PM.

Both the mechines() are in same time zone. if any body have idea?

Thanks

Raju.P

DCTM_Guru

Are these two different content server sharing the same repository (eg high availability configuration) or are they truly two different content servers or are you running the query on one content server and then running query on separate machine that is not a content server?

Your posting didnt provide enough details. Also, where are you running this query (eg DA, repoint, IDQL, etc)?

raju.pingili@intueorinfotech.com

Hi Johnny,

we are using two different content servers those are not sharing same repository. and we resloved this by using the fallowing querys

Select r_normal_tz from dm_docbase_config

Update dm_docbase_config objects set r_normal_tz = -18000

Thanks

Raju.P