thanks paul

I tried to user DATEFORMAT. but, it's applicable to that session only. It's not allowing me to change the total system time. When i try to execute this query...