• CONTEST ALERT - Experience the power of DDR5 memory with Kingston Click for details

Problem comparing date in MS Access and c# query

Not open for further replies.


Right off the assembly line
akshaycjoshi - Posted a few seconds ago

I am developing one application which requires me to compare date.The dataabse being MS access 2003.
When i execute the query in c# it does not show any record ,the date although matches with the date in database.
Where is the problem ?

The quey executed is

select * from finetable where fine_date=#1/9/2008 6:46:36 PM#

The record which matches it being

serial_no fine_date reg_no fine_place fine_code driver_name fine_officer vehicle_type book_info fine_amount
3 1/9/2008 6:44:55 PM sdfsd sdfdsfds d dsfsdf fsdfsdf Hero Puch dfsdf dsfds

Why it is not showing ??
Maybe coz the time is diff. But I want to compare dates only.

Please help me !


The Mighty Unkel!!!
Staff member
Please post some code which you wrote.. Also specify the exact data type of the date column in the database.
Not open for further replies.
Top Bottom