View Single Post
  #1 (permalink)  
Old 08-16-08, 11:20 AM
akshaycjoshi akshaycjoshi is offline
New Member
 
Join Date: Aug 2008
Posts: 1
Thanks: 0
Thanked 0 Times in 0 Posts
Problem comparing date in MS Access and c# query

Hi,
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
3 1/9/2008 6:44:55 PM 4521 india
Reply With Quote