Re: Birthday's Change

: Birthday's Change Thanks Adrian! Is that a false failure or a test to adapt? http://ci.apache.org/projects/ofbiz/logs/trunk/html/ Plain text: baseteststestStringFailure String->java.sql.Date(:0):default-timezone/locale expected:<1969-12-31> but w

Re: Birthday's Change

gt;>>>>> java.sql.Date is returned from jdbc drivers when the field is SQL >>>>>>> date, >>>>>>> the date will be set but the time will always be 00:00:00. The >>>>>>> java.sql.Date is only there to represent date only component of

Re: Birthday's Change

ax:* > > > > Please consider the environment before printing this email. > > > > > > From:Jacques Le Roux > To:dev@ofbiz.apache.org > Date:05/04/2014 11:37 > Subject:Re: Birthday's Change > --

Re: Birthday's Change

Ltd IT Ext:7036 Tel:01264 364311 Fax: Please consider the environment before printing this email. From: Jacques Le Roux To: dev@ofbiz.apache.org Date: 05/04/2014 11:37 Subject:Re: Birthday's Change Thanks Adrian! Is that a false failure or a te

Re: Birthday's Change

ate overrides toString method to return only >>>>>> the >>>>>> date) >>>>>> Because java.sql.Date extends java.util.Date and can be used in >>>>>> DateFormat >>>>>> class, applying a timezone with a negative offset will shift the

Re: Birthday's Change

*IT* *Ext:* 7036 *Tel:* 01264 364311 *Fax:* Please consider the environment before printing this email. From:Rupert Howell To: "dev@ofbiz.apache.org" Date:01/04/2014 09:27 Subject:Re: Birthday's Change -- M

Re: Birthday's Change

lyst* *Stannah Management Services Ltd* *IT* *Ext:* 7036 *Tel:* 01264 364311 *Fax:* Please consider the environment before printing this email. From:Rupert Howell To:"dev@ofbiz.apache.org" Date: 01/04/2014 09:27 Subject:Re: Birthday's Change

Re: Birthday's Change

java.sql.Date extends java.util.Date and can be used in >>>>>> DateFormat >>>>>> class, applying a timezone with a negative offset will shift the day >>>>>> to >>>>>> the >>>>>> previous day because time is ALW

Re: Birthday's Change

Rupert Howell To:"dev@ofbiz.apache.org" Date: 01/04/2014 09:27 Subject:Re: Birthday's Change -- My birth date is my birth date wherever I am in the world - it is not relative. My passport doesn't change as I travel through Ti

Re: Birthday's Change

From:Rupert Howell To:"dev@ofbiz.apache.org" Date: 01/04/2014 09:27 Subject:Re: Birthday's Change -- My birth date is my birth date wherever I am in the world - it is not relative. My passport doesn't change as I t

Re: Birthday's Change

> the >>>> previous day because time is ALWAYS set to 00:00:00 >>>> >>>> This also occurs in freemarker if you convert a java.sql.Date to a >>>> string >>>> using syntax such as ${date?string} where date is a java.sql.Date >>>&g

Re: Birthday's Change

same issue > > *Gareth Carter * > > *Software Development Analyst* > > *Stannah Management Services Ltd* > > *IT* > > *Ext:* > > 7036 > > *Tel:* > > 01264 364311 > > *Fax:* > > > > Please consider the environment before printing thi

Re: Birthday's Change

arter/freemarker *Gareth Carter * *Software Development Analyst* *Stannah Management Services Ltd* *IT* *Ext:* 7036 *Tel:* 01264 364311 *Fax:* Please consider the environment before printing this email. From:Rupert Howell To:"dev@ofbiz.apache.org" Date:

Re: Birthday's Change

: adrian.c...@sandglass-software.com To: dev@ofbiz.apache.org Date: 01/04/2014 11:57 Subject:Re: Birthday's Change How a DB manufacturer persists a date field is irrelevant. The issue here is how Java handles the date type in the JDBC driver and supporting code. I repeat:

Re: Birthday's Change

Howell To:"dev@ofbiz.apache.org" Date: 01/04/2014 09:27 Subject:Re: Birthday's Change -- My birth date is my birth date wherever I am in the world - it is not relative. My passport doesn't change as I travel through Timezones. Y

Re: Birthday's Change

ter Software Development Analyst Stannah Management Services Ltd IT Ext:7036 Tel:01264 364311 Fax: Please consider the environment before printing this email. From: Pierre Smits To: dev@ofbiz.apache.org Date: 01/04/2014 11:15 Subject:Re: Birthday's Ch

Re: Birthday's Change

Please consider the environment before printing this email. From: Pierre Smits To: dev@ofbiz.apache.org Date: 01/04/2014 11:15 Subject:Re: Birthday's Change Rupert, Please create the JIRA issue. Irrespective of what the users timezone is, the date must always be stored i

Re: Birthday's Change

"dev@ofbiz.apache.org" Date: 01/04/2014 09:27 Subject:Re: Birthday's Change -- My birth date is my birth date wherever I am in the world - it is not relative. My passport doesn't change as I travel through Timezones. Yet if I vi

Re: Birthday's Change

> > *IT* > > > > *Ext:* > > > > 7036 > > > > *Tel:* > > > > 01264 364311 > > > > *Fax:* > > > > > > > > Please consider the environment before printing this email. > > > > > > >

Re: Birthday's Change

vices Ltd* > > *IT* > > *Ext:* > > 7036 > > *Tel:* > > 01264 364311 > > *Fax:* > > > > Please consider the environment before printing this email. > > > > > > From:Rupert Howell > To:"dev@ofbiz.apache.org&qu

Re: Birthday's Change

alyst Stannah Management Services Ltd IT Ext:7036 Tel:01264 364311 Fax: Please consider the environment before printing this email. From: Rupert Howell To: "dev@ofbiz.apache.org" Date: 01/04/2014 09:27 Subject: Re: Birthday's Change My birth d

Re: Birthday's Change

Adrian - this is definitely incorrect, the Birth Date field is stored as a date field in Postgres so when OFbiz is converting the date to apply the user's timezone it is taking the time as 00:00: hence drastic changes over a 1 hour time change. I could accept what you are saying if the birthdat

Re: Birthday's Change

"dev@ofbiz.apache.org" Date: 01/04/2014 09:27 Subject: Re: Birthday's Change My birth date is my birth date wherever I am in the world - it is not relative. My passport doesn't change as I travel through Timezones. Yet if I view my passport information is OFBiz it will

Re: Birthday's Change

This behavior is clearly wrong. A 1 hour change in a timezone and people's birthdays are wrong! Postgres is storing the date fields as date fields. It is OFBiz that is applying the LOCAL timezone information to the date on line 977 of UtilDateTime. On 1 April 2014 09:27, wrote: > The date is st

Re: Birthday's Change

My birth date is my birth date wherever I am in the world - it is not relative. My passport doesn't change as I travel through Timezones. Yet if I view my passport information is OFBiz it will change, Dates need to be viewed as dates and be totally independent of timezones. I cannot think of a sing

Re: Birthday's Change

The date is stored as a java.sql.Timestamp - which is referenced to UTC. The UTC-referenced date is converted to the user's time zone during display. This is the intended behavior. -Adrian Quoting Rupert Howell : There's a definite problem with the way the dates are displayed in OFBiz. If

Re: Birthday's Change

See section 'Time zones and birthdays' in http://en.wikipedia.org/wiki/Birthday Pierre Smits *ORRTIZ.COM * Services & Solutions for Cloud- Based Manufacturing, Professional Services and Retail & Trade http://www.orrtiz.com On Tue, Apr 1, 2014 at 10:21 AM, Pierre Smits wro

Re: Birthday's Change

Rupert, That happens when the user shifts time zones while updating date fields. I guess that is why in legal documents Date of Birth and Date of Death always come a registration of a Place of Birth and Place of Death so that the correct time zone can be associated. Regards, Pierre Smits *ORR

Re: Birthday's Change

Rupert, You are right when you don't want to be to specific. But if you are specific and precise then a birthday needs to have a time zone associated. Remember it is not the birthday itself that shifts, but your viewpoint of it when changing locations (meaning time zones). Regarding. Pierre Smi

Re: Birthday's Change

Correct date I should say - not time On 1 April 2014 09:10, Rupert Howell wrote: > Hi Pierre, > > Yes I am aware of that. The 18 date fields are being stored correctly. > They are however being displayed incorrectly because they are having the > Timezone applied on line 977 UtilDateTime. If

Re: Birthday's Change

Hi Pierre, Yes I am aware of that. The 18 date fields are being stored correctly. They are however being displayed incorrectly because they are having the Timezone applied on line 977 UtilDateTime. If you carry out the test I described in the previous email. Birth Date on the person entity is the

Re: Birthday's Change

Hmm. Digging a bit deeper I see that birthday is persisted as a date. So that shouldn't be creating issues. Pierre Smits *ORRTIZ.COM * Services & Solutions for Cloud- Based Manufacturing, Professional Services and Retail & Trade http://www.orrtiz.com On Tue, Apr 1, 2014

Re: Birthday's Change

Rupert, A date should not be stored as a date-time, but as a date. This appears throughout the entire spectrum of apps where dates are intended. Over 600 entity fields are designated as date-time, 18 entity fields are designated as date and 8 as time. Regards, Pierre Smits *ORRTIZ.COM

Birthday's Change

There's a definite problem with the way the dates are displayed in OFBiz. If you enter a birthday with your local timezone set to UTC, then change the timezone to -12, the birthday changes to the previous day. This is clearly wrong and is really apparent if you have your Server Timezone set to GB.