can any body help me .. its urgent
Moderator: General Moderators
can any body help me .. its urgent
HI Friends....
i want to know that how we can fetch data from the database table in corresponding to current date of the day..
in the database the field is of datetime type..& there is date is like 2007-07-03 03:30:30.
so i have to fetch data corresponding to date but there is time is also associated with the date then how can i match the date with the database field in select query..
Please help me out for this.....
i want to know that how we can fetch data from the database table in corresponding to current date of the day..
in the database the field is of datetime type..& there is date is like 2007-07-03 03:30:30.
so i have to fetch data corresponding to date but there is time is also associated with the date then how can i match the date with the database field in select query..
Please help me out for this.....
- superdezign
- DevNet Master
- Posts: 4135
- Joined: Sat Jan 20, 2007 11:06 pm
php date..
yes i know the date function ..
but there is time also associated in the table field .. & i hv to match from the date only .. so how can i drop time & only get the date from database...
but there is time also associated in the table field .. & i hv to match from the date only .. so how can i drop time & only get the date from database...
- superdezign
- DevNet Master
- Posts: 4135
- Joined: Sat Jan 20, 2007 11:06 pm
php date ..
HI..
i need to bifercate date with time wich is is database ... & check with my condition whether it is true or not....
i need to bifercate date with time wich is is database ... & check with my condition whether it is true or not....
- feyd
- Neighborhood Spidermoddy
- Posts: 31559
- Joined: Mon Mar 29, 2004 3:24 pm
- Location: Bothell, Washington, USA
[url=http://forums.devnetwork.net/viewtopic.php?t=30037]Forum Rules[/url] Section 1.1 wrote:2. Use descriptive subjects when you start a new thread. Vague titles such as "Help!", "Why?" are misleading and keep you from receiving an answer to your question.
- superdezign
- DevNet Master
- Posts: 4135
- Joined: Sat Jan 20, 2007 11:06 pm
Re: php date ..
... Alzheimer's?djdon11 wrote:HI..
i need to bifercate date with time wich is is database ... & check with my condition whether it is true or not....
- superdezign
- DevNet Master
- Posts: 4135
- Joined: Sat Jan 20, 2007 11:06 pm
- superdezign
- DevNet Master
- Posts: 4135
- Joined: Sat Jan 20, 2007 11:06 pm