How can use Distinct query
Posted: Fri Jul 25, 2008 12:35 am
Hello,
I need your help to display the records from a table. In my table there is datetime field. I want to extract the records in a date (without time) from the list of records. I have used distinct query. but not works.
First i need to display the dates (without time) in a <select> tag. For example if there is 10 records in todays date and 5 records in yesterdays date. In these 15 records there is seperate time. But i need only 2 values only date without time (today's date & yesterday's). Can u help?
Please give advice.. Please help me..
I need your help to display the records from a table. In my table there is datetime field. I want to extract the records in a date (without time) from the list of records. I have used distinct query. but not works.
First i need to display the dates (without time) in a <select> tag. For example if there is 10 records in todays date and 5 records in yesterdays date. In these 15 records there is seperate time. But i need only 2 values only date without time (today's date & yesterday's). Can u help?
Please give advice.. Please help me..