Code: Select all
Query.SQL.Text := 'SELECT CAST(:Date AS timestamp)';
Query.ParamByName('Date').Value := '2015-01-01';
Query.Open;
// Query.Fields[0].Value is e.g. "13/12/2014 12:58:48"
Code: Select all
Query.SQL.Text := 'SELECT CAST(:Date AS timestamp)';
Query.ParamByName('Date').Value := '2015-01-01';
Query.Open;
// Query.Fields[0].Value is e.g. "13/12/2014 12:58:48"