Working with Dates in where clause
932957Apr 24 2012 — edited Apr 24 2012Hi,
I am using Oracle for few years now but always have hard time when it comes to using Date in where clause. Can someone please give a crash course on this? if the NLS_DATE_FORMAT is 'DD-MON-RR' then how should one specify date in where clause assuming that the column has DATE datatype. Tools such as TOAd display dates as mm/dd/yyyy hh:mi:ss and that confuses me a lot. I know that is setting in the tool to display dates in tool itself. If I want to display records that have been updated on 14-april-2012 then how should format be mentioned in where clause(assume column name as ls_updt_ts) .
Thanks