Posts by Cristiano Gonçalves • 11 points
3 posts
-
0
votes3
answers80
viewsA: Doubt with IBM DB2 rule
I got a solution for Postgresql with a friend , but would like to find for ibm db2 select n.* from schema.tabela n where cast( (cast( n.datavenda as TIMESTAMP with time zone)) as date) =…
-
0
votes3
answers80
viewsA: Doubt with IBM DB2 rule
As I would add the minutes together with the time to the ibm db2 database. The code below is in SQL SERVER. select * from vendas v where convert(date, DATAVENDA) = convert(date, getdate()) and CASE…
-
0
votes3
answers80
viewsQ: Doubt with IBM DB2 rule
Guys I’m having a hard time transcribing this sql server structure to IMB DB2. Could someone help me. with cte as ( select CASE WHEN CONVERT(datetime, format( getdate(), 'HH:MM') ) BETWEEN '06:00'…