The database is sql server 2000. And the programming language is java.
The thing is I have solved the initial problem. but now the problem is to take care of day light saving.
The 2 paramaters bring passed are: the datetime value and the time_zone like GMT-6:00.
this second field will determine how much from the GMT have i got to substract to get the local time. I have hard-coded such comparisons becoz there is a fixed number...

Hi people,

I have a function which will receive 2 parameters:the date field in GMT time and the user's time zone.

I have to return a datetime field in the user's time.
the thing is the server records the GMT time and that is put into the database.
but when reports are to be generated for a user who doesn't belong to the GMT time zone, for eg say INDIA, then i want the time to be shown as of India's time...