Sql Query for :Converting full date into AM/PM with Time. only.

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

 

Dhimmar u can do this by building a PL/SQL procedure like the following:-

Code:

str:=SUBSTR(time,12,2)
num:=TO_NUMBER(str)
num:=num-12
if num>0 then
Dbms_output.put_line(concat(concat(concat(Concat(to_string(num),':'),'00'),' '),'PM))
else
num:= 12+(num)
Dbms_output.put_line(concat(concat(concat(Concat(to_string(num),':'),'00'),' '),'AM))
end if