It would be better to add two elements for type BigDecimal in service-builder.

constraint-precision: the precision
constraint-scale: the scale

For example,



constraint-precision: 5
constraint-scale: 2

Hi Hitoshi,

Thanks to reminder me. Yes, I do have a plan to generate a fix patch for this.

http://issues.liferay.com/browse/LPS-15233

But there are several patches pending in my plates. I will try do this as early as possible.

Thanks

Jonas

==================
The Author of Liferay Books:
Liferay development cookbook: Liferay Portal Systems Development (for liferay portal 6.1 or above version)
Liferay User Interface Development
Liferay Portal 6 Enterprise Intranets
Liferay Portal 5.2 Systems Development
Liferay Portal Enterprise Intranets

Hi Yaun,

You have suggested the steps below but you have not mentioned in which files we have to make these changes.

Also I want the support for TimeStamp datatype. Please guide me what I need to do make it work with service builder or in Liferay?

Thanks and Regards
Suman Kumar

Hi Jonas,

In our project we have display many reports which are time based like, How many P1 alerts came in past 30 mins or 1 hr etc?

So I have to maintain the time details in the createdDate column. So TimeStamp will be helpfull in all the cases where we are doing this hourly based reporting.

Also in the record detail we need to show the proper time of creation of the record.

I am sure people must be using the time components (hh:mm:ss AM) in there project. If its currently not supported in Liferay then I will like to know what alternate option we have?

Thanks and Regards
Suman Kumar

Hi Jones,

My requriement is not jsut to display the data time, But to also save and retrive it. So please clarify the below query

Suppose I have a table column 'createdDate' with datatype 'TIMESTAMP' in MySQL db

and below is the sample service.xml for it.

<entity name="Bike" local-service="true" remote-service="false">
<column name="bikeId" type="long" primary="true"/>
<column name="createdDate" type="Date"/>
</entity>

So now BikeLocalServiceUtil.getBike(id) will return Bike object and now if I use the below code I should get the TimeStamp value as saved in the db.

dateFormatDateTime.format(bike.getCreatedDate()) //using FastDateFormatFactoryUtil

Will I get the TimeStamp value?

I tried to under the FastDateFormatFactoryUtil implementation but it doen't have documentation so I am unable to understand it.
Please confirm my above undertatnding. I am also trying out one sample at my end.

Thanks and Regards
Suman Kumar