Pari13 -1 Junior Poster in Training

Hi All Developer,

I am waiting for Query that will Converting full date into AM/PM with Time. only.
in Sql Server.

For Example:
2010-06-24 16:00:00.000 will be giving result -->04:00 PM

2010-09-24 01:00:00.000 will be giving result -->01:00 AM


Wait For your Reply.

Thanks.
Dhimmar