Hi,
In my application i convert the date time as Server date time to User date time, because we are saving the record with server date time. While showing the records to user we are converting to user date time.

In HQL query we can convert the date time Using GMT time like this
SELECT CONVERT_TZ('2012-04-30 22:22:10','+5:30','+00:00');

But i need to done in Criteria level. How i can do for that??


Thanks
Sivabharathi S

hi ssivabharathi SQL Server provides a number of options you can use to format a date/time string. One of the first considerations is the actual date/time needed. The most common is the current date/time using getdate(). This provides the current date and time according to the server providing the date and time. If a universal date/time is needed, then getutcdate() should be used. To change the format of the date, you convert the requested date to a string and specify the format number corresponding to the format needed. Below is a list of formats and an example of the output:

Hi,

Thanks for your reply. I accepted we can convert in Query itself. But we are using only criteria in our application not using HQL query. One more thing i dont want to convert current date time. I want convert the datetime what we have saved before in the DB.

For example User date time 29-04-2012 10:00 AM. The server time will be 29-04-2012 10:00 PM. So the both times varying. Now user saving some data we storing the date time as 29-04-2012 10:00 PM (as server time). But while showing to user 29-04-2012 10:00 AM.

So i need convert the date time depends upon user. I know the user time zone from that i can convert through java using simpleDateFormat class. If any method in criteria itself convert timezone while fetching the record.