SQL todays date

General Discussion
1

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'

or

WHERE CONVERT(VARCHAR(10), DATE_DT, 101) = CONVERT(VARCHAR(10), GETDATE(), 101)

thanks.

2

also when I try:

WHERE 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

3

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

4

thank you that sent me in the right direction.