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..
How can use Distinct query
Moderator: General Moderators
- Christopher
- Site Administrator
- Posts: 13596
- Joined: Wed Aug 25, 2004 7:54 pm
- Location: New York, NY, US
-
vcodeinfotec
- Forum Newbie
- Posts: 10
- Joined: Sat Jul 12, 2008 2:08 am
Re: How can use Distinct query
Hello,
I need only date value for 'distinct' not including the time..
2008-07-06 16:46:15
2008-07-06 16:47:44
2008-07-06 10:18:25
2008-07-24 14:38:25
If these are the records i need to get
2008-07-06
2008-07-24
Please help
I need only date value for 'distinct' not including the time..
2008-07-06 16:46:15
2008-07-06 16:47:44
2008-07-06 10:18:25
2008-07-24 14:38:25
If these are the records i need to get
2008-07-06
2008-07-24
Please help
- Christopher
- Site Administrator
- Posts: 13596
- Joined: Wed Aug 25, 2004 7:54 pm
- Location: New York, NY, US
-
vcodeinfotec
- Forum Newbie
- Posts: 10
- Joined: Sat Jul 12, 2008 2:08 am
Re: How can use Distinct query
thanks..