NO OF DAYS BETWENN TWO DIFFERENT DATES.

Dev Shed Forums Sponsor:

May 31st, 2000, 04:42 AM

chayani

Junior Member

Join Date: Mar 2000

Posts: 9

Time spent in forums: < 1 sec
Reputation Power: 0

how to calculate the no of days between two different dates.

May 31st, 2000, 06:25 AM

Shiju Rajan

.Net Developer

Join Date: Feb 2000

Location: London

Posts: 987

Time spent in forums: 3 h 26 m 22 sec
Reputation Power: 14

i guess you are using this for a mysql query.

if it is for mysql query then use TO_DAYS() for doing it .

"SELECT field1,field2 FROM tbl_name WHERE TO_DAYS(now())-TO_DAYS(datefield)=7";

------------------
SR -
shiju.dreamcenter.net

"The fear of the LORD is the beginning of knowledge..."

Viewing: Dev Shed Forums > Programming Languages > PHP Development > NO OF DAYS BETWENN TWO DIFFERENT DATES.

« Previous Thread | Next Thread »

Developer Shed Advertisers and Affiliates

Thread Tools	Search this Thread
Email this Page	Search this Thread: Advanced Search
Display Modes	Rate This Thread
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode	Rate This Thread:

Posting Rules
You may not post new threads You may not post replies You may not post attachments You may not edit your posts vB code is On Smilies are On [IMG] code is On HTML code is Off

View Your Warnings | New Posts | Latest News | Latest Threads | Shoutbox

Forum Jump