SQL load script for convert time stamp into Month Year ?

[paulyeo11]

Hi All

after i manage to load the SQL data into QV , i have a field name = date_time . i like to convert into day month year ? my existing script as below :-

CONNECT TO [Provider=SQLOLEDB.1;Persist Security Info=False;User ID=SA;Initial Catalog=andonDatabas;Data Source=Paul;Use Procedure for Prepare=1;Auto Translate=True;Packet Size=4096;Workstation ID=PAUL;Use Encryption for Data=False;Tag with column collation when possible=False];

select * from record_produksi_plc;

select * from record_downtime_plc;

select * from record_reject_detail_plc;