I created a test table using
Code: Select all
CREATE TABLE testtable ( letter CHAR(1) , date_date DATE, date_str VARCHAR(10) );
INSERT INTO testtable (letter, date_date, date_str) VALUES ('A', '2018-03-12', '2018-03-12');
Code: Select all
SELECT letter, date_date, date_str FROM testtable;
Code: Select all
letter | date_date | date_str
'A' | '2018-03-12' | '2018-03-12'
Code: Select all
letter | date_date | date_str
'A' | '12/03/2018' | '2018-03-12'
Code: Select all
SELECT * FROM testtable WHERE date_date = '12/03/2018';
This can be shown by the delphi code
Code: Select all
var TheDate : string;
begin
TMyQuery1.SQL.Clear;
TMyQuery1.SQL.Add('SELECT date_date FROM testtable;');
TMyQuery1.open ;
TheDate := TMyQuery1.FieldByName('date_date').AsString ;
ShowMessage(theDate);
end;
I realise that I can get the result I want by using CAST or CONVERT eg
Code: Select all
SELECT CONVERT(date_date, char) FROM testtable;