CODEWITHSUNDEEP
sqloracle-databaseoracle11g
user11485402
user11485402

Reputation:

To_char ,To_date

how do you become conform with this code, only dates of 2019 appear to me? You are not changing To_char. 

SELECT GUEST.GNO, GUEST.GLASTNAME, GUEST.GFIRSTNAME, BOOKING.gNO, BOOKING.GINDATE 
FROM GUEST, BOOKING
WHERE GUEST.GNO = BOOKING.gNO AND BOOKING.GINDATE = TO_CHAR (GINDATE,'DD/MM/YYYY');

Upvotes: 0

Views: 279

Answers (1)

Gordon Linoff
Gordon Linoff

Reputation: 1269543

I am interpreting your query as you want bookings in 2019. If so, then query should look more like this:

SELECT g.GNO, g.GLASTNAME, g.GFIRSTNAME, b.gNO, b.GINDATE 
FROM GUEST g JOIN
     BOOKING b
     ON g.GNO = b.gNO 
WHERE b.GINDATE >= DATE '2019-01-01' AND
      b.GINDATE < DATE '2020-01-01';

Of course, there might be slight variations depending on your database.

Upvotes: 1

Related Questions