just check up msdn……..there you would be able to out a number of time formats that can be used….
I will give you an example …so lets say the time field your using is GETDATE() (current date)
so apply CONVERT(VARCHAR,GETDATE(),111) …………..and you would get the date in the following format
May 22 2008 11:26PM
The websit i mentioned would really helpful
‘‘Unless man increases in wisdom as much as in knowledge, increase of knowledge will only be increase of sorrow.’’