Issue about displaying and reading timestamps

Previous Topic Next Topic
 
classic Classic list List threaded Threaded
3 messages Options
Reply | Threaded
Open this post in threaded view
|

Issue about displaying and reading timestamps

Rashko Rejmer
Hi all,

I have noticed that all the timestamps that are read from the database
are displayed in this format:
 - yy-MM-dd HH:mm:ss.S
with only one sign for milliseconds.

the funny thing is that if we read a value from the DB like this
2001-01-01 12:00:00.001 it is rounded to 2001-01-01 12:00:00.1

This issue in visible in this situation(but also in may others):
 - go to security group FULLADMIN
https://demo.hotwaxmedia.com/partymgr/control/EditSecurityGroupUserLogins?groupId=FULLADMIN
 - then add user to this security group with parameter fromDate =
2001-01-01 12:00:00.001

In the database fromDate parameter is kept this way 2001-01-01
12:00:00.001, but when you try to access it you get 2001-01-01
12:00:00.1. So you are not able anymore to remove this association.

I have made example on the demo server with system user login:
https://demo.hotwaxmedia.com/partymgr/control/removeUserLoginFromSecurityGroup?userLoginId=system&groupId=FULLADMIN&fromDate=2001-01-01%2012:00:00.1

Regards,
Rashko Rejmer

Reply | Threaded
Open this post in threaded view
|

Re: Issue about displaying and reading timestamps

Adrian Crum
Rashko,

You are correct. There seems to be a problem with rendering Timestamps -
probably due to localization issues. Open a Jira issue and I'll get to
it sometime soon.

-Adrian

Rashko Rejmer wrote:

> Hi all,
>
> I have noticed that all the timestamps that are read from the database
> are displayed in this format:
>  - yy-MM-dd HH:mm:ss.S
> with only one sign for milliseconds.
>
> the funny thing is that if we read a value from the DB like this
> 2001-01-01 12:00:00.001 it is rounded to 2001-01-01 12:00:00.1
>
> This issue in visible in this situation(but also in may others):
>  - go to security group FULLADMIN
> https://demo.hotwaxmedia.com/partymgr/control/EditSecurityGroupUserLogins?groupId=FULLADMIN
>  - then add user to this security group with parameter fromDate =
> 2001-01-01 12:00:00.001
>
> In the database fromDate parameter is kept this way 2001-01-01
> 12:00:00.001, but when you try to access it you get 2001-01-01
> 12:00:00.1. So you are not able anymore to remove this association.
>
> I have made example on the demo server with system user login:
> https://demo.hotwaxmedia.com/partymgr/control/removeUserLoginFromSecurityGroup?userLoginId=system&groupId=FULLADMIN&fromDate=2001-01-01%2012:00:00.1
>
> Regards,
> Rashko Rejmer
>
>
Reply | Threaded
Open this post in threaded view
|

Re: Issue about displaying and reading timestamps

Rashko Rejmer
Thanks Adrian for the quick reply. I will create jira for this in a
minute.

Regards,
Rashko Rejmer

On Fri, 2008-05-30 at 12:31 -0700, Adrian Crum wrote:

> Rashko,
>
> You are correct. There seems to be a problem with rendering Timestamps -
> probably due to localization issues. Open a Jira issue and I'll get to
> it sometime soon.
>
> -Adrian
>
> Rashko Rejmer wrote:
> > Hi all,
> >
> > I have noticed that all the timestamps that are read from the database
> > are displayed in this format:
> >  - yy-MM-dd HH:mm:ss.S
> > with only one sign for milliseconds.
> >
> > the funny thing is that if we read a value from the DB like this
> > 2001-01-01 12:00:00.001 it is rounded to 2001-01-01 12:00:00.1
> >
> > This issue in visible in this situation(but also in may others):
> >  - go to security group FULLADMIN
> > https://demo.hotwaxmedia.com/partymgr/control/EditSecurityGroupUserLogins?groupId=FULLADMIN
> >  - then add user to this security group with parameter fromDate =
> > 2001-01-01 12:00:00.001
> >
> > In the database fromDate parameter is kept this way 2001-01-01
> > 12:00:00.001, but when you try to access it you get 2001-01-01
> > 12:00:00.1. So you are not able anymore to remove this association.
> >
> > I have made example on the demo server with system user login:
> > https://demo.hotwaxmedia.com/partymgr/control/removeUserLoginFromSecurityGroup?userLoginId=system&groupId=FULLADMIN&fromDate=2001-01-01%2012:00:00.1
> >
> > Regards,
> > Rashko Rejmer
> >
> >