Query with date and time in sql server

Question

I have a field in the "char" type bank, I am returning the dates this way:

select
   CONVERT(VARCHAR(20),HORA_FECHAMENTO) as HORA_FECHAMENTO,
   CONVERT(VARCHAR(20), DATEADD(hour, +0, getdate()), 120) as HORA_ATUAL 
  from TB_ESTRACAO   
where IDEXTRACAO = 5

how could I bring the two equal dates along with the time

Answer 1

I’m not sure that’s what you’re looking for, but you can work that way:

Schema test:

CREATE TABLE teste
    ([HORA] VARCHAR(20))
;

INSERT INTO teste
    ([HORA])
VALUES
    ('24:00'),
    ('10:00'),
    ('5:20')
;

---

SELECT
CONCAT(CONVERT(CHAR(10), getdate(),126),' ',HORA,':00') AS HORA_FECHAMENTO,
CONVERT(VARCHAR(20), DATEADD(hour, +0, getdate()), 120) AS HORA_ATUAL 
FROM teste

Explaining the line: CONCAT(CONVERT(CHAR(10), getdate(),126),' ',HORA,':00') I only take the date in the format yyyy-mm-dd and concateno with the time that is in the comic, along with the seconds, which also were not defined.

Note that there are logical errors in your comic book, the ideal would be to work the two dates with the same format, yyyy-mm-dd hh:mm:ss, the way you are "forcing" the closing day to be today.

See working on Sqlfiddle

---

The function concat is not implemented in sql-server 2008, how output the solution can be:

SELECT
CONVERT(CHAR(10), getdate(),126)+' '+HORA+':00') AS HORA_FECHAMENTO,
CONVERT(VARCHAR(20), DATEADD(hour, +0, getdate()), 120) AS HORA_ATUAL 
FROM teste