Results 1 to 2 of 2
16-08-2008, 07:39 PM #1
- Join Date
- Aug 2008
Problem comparing date in MS Access and c# query
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 !
18-08-2008, 12:39 AM #2
Re: Problem comparing date in MS Access and c# query
Please post some code which you wrote.. Also specify the exact data type of the date column in the database.the cake is a lie
By AHHNPANTH in forum QnA (read only)Replies: 1Last Post: 07-03-2009, 12:53 AM
By skghosh44 in forum Software Q&AReplies: 16Last Post: 05-09-2007, 11:26 PM
By Anup Nair in forum Technology NewsReplies: 1Last Post: 25-03-2007, 10:51 PM
By legolas in forum Open SourceReplies: 6Last Post: 02-03-2006, 02:59 PM
By un in forum QnA (read only)Replies: 4Last Post: 15-09-2005, 10:05 PM