sql select query issue...plz help

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

General SQL Server Forums

New to SQL Server Programming

sql select query issue...plz help

Author

Topic

bluestar
Posting Yak Master

133 Posts

Posted - 2010-07-01 : 10:22:39

hello I have this following sql query

select count(1) from dw.billing_fact
where billing_date_key between 7501 and 7865
and company_key in (6018, 6010)
and billing_doc_no not like '00%'
and DW_CREATE_DATE = '6/11/2010 1:29:38 PM'

when i am running this,its giving me error ORA-01843: not a valid month

the column DW_CREATE_DATE datatype is DATE.

and there is entry in the table for 6/11/2010 1:29:38 PM.

I want my query to show me result which has DW_CREATE_DATE on 6/11/2010.

please help,how to do that.

Thank You.

Sachin.Nand

2937 Posts

Posted - 2010-07-01 : 10:26:15

Seems you are using Oracle.This is an Micrsoft SQL Server Forum.
Please post your question in an Oracle forum.

Limitations live only in our minds. But if we use our imaginations, our possibilities become limitless.

PBUH

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources