trying to return columns with todays date and so far nothing ive found on any of the tutorials ive been reading seems to work…
any ideas on either of these methods on what im doing wrong?
WHERE DATE_DT BETWEEN '2013-12-11 00:00:00' AND '2013-12-11 23:59:59'
WHERE CONVERT(VARCHAR(10), DATE_DT, 101) = CONVERT(VARCHAR(10), GETDATE(), 101)
also when I try:
t_stamp >= '2010-03-20 08:00:00' AND
t_stamp <= '2010-03-20 13:00:00'
straight out of the book I get: ORA-01861 literal does not match format string
The examples that you see are for MySQL and SQL Server, not for Oracle.
For Oracle you probably need to use the TO_DATE function.
Examples here: stackoverflow.com/questions/2369 … ween-query
thank you that sent me in the right direction.