AnsweredAssumed Answered

Parse from Execute SQL

Question asked by aydinbuyukyilmaz on Sep 20, 2018
Latest reply on Sep 20, 2018 by aydinbuyukyilmaz

I am preparing a schedule system and I need to show well format like ( 16:00 - 18:00 / Rhinoplasti ) returns value from ExecuteSQL as follows;

 

ExecuteSQL ( "SELECT \"Time Start\", \"Time End\", \"İslem_Turu\" FROM calendar_data where \"Date Start\" = ? order by \"Time Start\" desc "; "";""; calendar_data::Date Start )

 

Current result is;

 

16:00:00,18:00:00,Rhinoplasti

15:00:00,15:30:00,Full Face  Botox

14:45:00,15:00:00,Full Face  Botox

14:30:00,14:40:00,PRP Yüz

14:00:00,16:15:00,Hi-Fu Yüz

14:00:00,14:15:00,Full Face  Botox

14:00:00,14:30:00,Kontrol

13:45:00,13:55:00,Full Face  Botox

13:30:00,13:45:00,Kontrol

13:00:00,13:30:00,Kontrol

12:55:00,13:00:00,Kontrol

11:15:00,11:30:00,Kontrol

11:00:00,12:00:00,Dermoloji

11:00:00,11:10:00,PRP Yüz

10:45:00,11:15:00,Kontrol

10:30:00,11:00:00,Full Face  Botox

10:30:00,11:00:00,Lazer Kontrol

10:00:00,10:30:00,Muayene

Outcomes