Date formats in Query Reporter

[marksy99]

How can I match a specific value to a date field.
I am trying to something like the following
Select name
from TableA
where d_birth = '1969-07-01'

In sql plus we needed to alter our session using the following: alter session set NLS_DATE_FORMAT='';

Is there something similar I can do here or is there another write I can write the query?

 

[Marco Kalter]

You need to use the to_date() function and supply the correct format in the query. For example:

Select name
from TableA
where d_birth = to_date('1969-07-01', 'yyyy-mm-dd')