I have this query...
PHP Code:
SELECT idBloque ,nombre,
'DESDE' = CASE
WHEN desde >= 1200 THEN CONVERT(varchar , desde - 1200 ,103) + ' PM'
ELSE CONVERT(varchar , desde , 103) + ' AM'
END,
'HASTA' = CASE
WHEN hasta >= 1200 THEN CONVERT(varchar , hasta - 1200 ,103) + ' PM'
ELSE CONVERT(varchar , hasta , 103) + ' AM'
END
FROM BLOQUE
and the results are ok.. but in the results i need a separator included between the text.. this is the set of result this query gives me:
ID nombre DESDE HASTA
4 Bloque A 730 AM 900 AM
5 Bloque B 910 AM 1120 AM
9 Bloque C 1125 AM 1245 PM
10 Bloque D 130 PM 300 PM
11 Bloque E 310 PM 440 PM
12 Bloque F 530 PM 700 PM
13 Bloque G 740 PM 810 PM
14 Bloque H 820 PM 930 PM
15 Bloque I 930 PM 1100 PM
Till this point its ok.. but i need to insert a : in the DESDE and HASTA COLULMN... and get something like this:
ID nombre DESDE HASTA
4 Bloque A 7:30 AM 9:00 AM
5 Bloque B 9:10 AM 11:20 AM
9 Bloque C 11:25 AM 12:45 PM
.......
notice the : in both columns..
So how can i do that??.. thank you guys!
Dev Shed Forums Sponsor:
June 27th, 2003, 03:21 PM
Del.icio.us
Digg
Google
Spurl
Blink
Furl
Simpy
Y! MyWeb
Linear Mode
